Please send resume to ami...@idctechnologies.com
*Need Local to WI or IL*
*Location* - Madison, WI
*1 year contract *
*Try to have someone LOCAL to WI or Closer *
*SQL Server Reports Developer*
*SQL Server Tools:*
- Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server
Management Studio, DTS, SSIS, SSRS, SSAS, Sharepoint.
- MS SQL Server 2008 R2, SQLCMD, Microsoft Office 2010/2007/2003,
- Windows XP/NT/2000/2003/2008, DOS
- Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports
8.5,10,XI,R2, Business Objects, Microsoft office 2003/2007
- Expertise in SQL Server Integration Services (SSIS) and SQL Server
Reporting Services (SSRS) with good knowledge on SQL Server Analysis
- Experienced in report writing using SQL Server Reporting Services
(SSRS) and creating various types of reports: Drill Down, Parameterized,
Cascading, Conditional, Table, Matrix, Chart and Sub-Reports.
- Experienced in developing, monitoring, extracting and transforming
data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
- Excellence in high level design of ETL DTS packages & SSIS packages
for integrating data using OLE DB connection from heterogeneous sources
like (Excel, CSV, Oracle, flat file, text format data) by using multiple
transformations provided by SSIS such as Data Conversion, Conditional
Split, Bulk Insert, Merge and union all.
- Experienced in developing reports on SSRS on SQL Server
(2000/2005/2008). Sound experience and understanding of SSAS, OLAP cube and
- Experienced in writing expressions in SSRS and Expert in fine tuning
the reports. Experience in creating many Drill Through and Drill Down
reports using SSRS.
- Excellent knowledge in creating databases, tables, stored procedures,
DDL/DML triggers, views, user defined data types, functions, cursors and
indexes using T-SQL.
- Significant ability to create and manage various database objects like
tables and views.
- Worked extensively on ETL process using SSIS package.
- Experienced in data conversion and data migration using SSIS and DTS
services across different databases like Oracle, MS access and flat files.
- Experienced in using T-SQL in SQL Server 2008 platforms.
- Experienced in Performance Tuning and Query Optimization.
- Designed dashboards, scorecards and reports using multiple KPI’s, OLAP
charts and SSRS reports with PPS.
- Transformed data from one server to other servers using tools like
Bulk Copy Program (BCP),Data Transformation Services (DTS) and SQL Server
Integration Services (SSIS)
- Experienced in maintenance and administration of SSIS by creating
jobs, alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
- Experienced in SQL Server DTS and SSIS (Integration Service) package
design, constructing, and deployment
- Experienced in creating packages to transfer data between ORACLE, MS
ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
- Expert in creating Parameterized Reports.
- Hands on experience in creating Star Schema and SnowFlake schemas.
- Excellent analytical, communication and interpersonal skills.
Proficient in technical writing and presentations and a good team player.
- Ability to work independently or as part of a team to accomplish
critical business objectives and to make decisions under pressure.
*Must Have Skills:*
- *SQL Server 2012 * 5 Yrs.*
- *Working knowledge of SQL Server T-SQL * 2 Yrs.*
- *SSIS (SQL Server Integration Services) * 3 Yrs.*
- *ETL * 2 Yrs.*
- *Experience in developing ETL logic * 2 Yrs.*
- *Microsoft SQL Server Reporting Services * 3 Yrs.*
- *SQL Server BI Tools (Report Builder) * 2 Yrs.*
- *SSRS * 2 Yrs.*
*Thanks and Regards,*
*1851 McCarthy Blvd. Suite 116, Milpitas, CA 95035*
*Email: **ami...@idctechnologies.com* <ami...@idctechnologies.com>
*408-459-3314 Web: **www.idctechnologies.com*
You received this message because you are subscribed to the Google Groups "SAP
or Oracle Financials" group.
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to firstname.lastname@example.org.
Visit this group at https://groups.google.com/group/sap-or-oracle-financials.
For more options, visit https://groups.google.com/d/optout.