Hi,
Please send resume to ami...@idctechnologies.com *Need Local to WI or IL* *Programmer-Analyst * *Location* - Madison, WI *1 year contract * *Try to have someone LOCAL to WI or Closer * *SQL Server Reports Developer* *REQUIREMENTS:* *SQL Server Tools:* - Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, Sharepoint. *Database:* - MS SQL Server 2008 R2, SQLCMD, Microsoft Office 2010/2007/2003, MS-Access. *Operating System:* - Windows XP/NT/2000/2003/2008, DOS *Tools:* - Erwin Data Modeler, MS Visio, SAS/Access, Crystal Reports 8.5,10,XI,R2, Business Objects, Microsoft office 2003/2007 *Experience:* - Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). - 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 architecture. - 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,* *Warm Regards,* *Amit Vajpayee* *IDC Technologies* *1851 McCarthy Blvd. Suite 116, Milpitas, CA 95035* *Email: **ami...@idctechnologies.com* <ami...@idctechnologies.com> *Phone: * *408-459-3314 Web: **www.idctechnologies.com* <http://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 sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.