SUMMARY

• 7 Yrs of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008 R2/2005/2000 in Development, Test and Production Environments with various business domains like HealthCare, Banking.
• Migration of SSRS reports from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
• Good Experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Developing reports on SSRS on SQL Server (2005/2008/2008 R2).
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export.
• ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse Environment.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica and Data Stage.
• Proficient experience in different Databases like Oracle, SQL Server and DB2.
• Working Experience on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
• Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008 and Transformation
• Created Reports with complex formulas and to query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T - SQL.
• Good Knowledge of Integration Services (SSIS), Reporting Services (SSRS)
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from /2008
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Good understanding in Oracle 9i/10g Database.
• Good knowledge on Informatica.
• Experience in Tuning SQL queries and T-SQL queries, MDX & improving the performance of the queries.
• Worked Extensively on ETL process using SSIS package.
• Good knowledge in Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL 2012/2008/2005/2000.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal and communication skills.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, SQL Server Management Studio, Business Intelligence Development Studio.

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica 9.5.1

Reporting Tools: SQL Server Reporting Services (SSRS) (2005/2008 R2/2012), MS Excel

Database: MS SQL Server 2012/2008R2/2005, DB2, Oracle

Programming: T-SQL, PL-SQL, C, MYSQL

Operating Systems: Windows NT 2000/2003 Server, Windows XP/7, Unix/Linux, Mac.

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Camp Hill, PA

SSRS Developer

Responsibilities:

• Currently working on a health insurance project/ Access Health which deals with health care data, used to get health care data from CT State.
• Deals with Claims, Providers, Recipients health care data, Program type, Sub-program type, Age groups, Premium Amounts.
• Involved in generating periodic reports based on the statistical analysis of the data from various time frame and division using SQL server Reporting Services (SSRS).
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Identified and defined multiple Datasets to generate sub reports based on main parameterized report.
• Used matrix to group based on row & column to find appropriate values i.e. Total members in a particular program, particular sub program, age group, Gender etc.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters using SSRS.
• Involved in developing various Drill-Through and Drill-Down reports based on the business requirements using SSRS 2012.
• Developed and maintains high level Dashboards, Sub-reports, Ad-hoc reports, Pie-charts.
• Developed Reports for business end users using Report Builder tool and SSRS Report Manager.
• Involved in tracking and fixing Data warehouse issues created in an online tool JIRA.
• Involved in the Data warehouse Defect Triage and Issue Resolution Process.
• Addressed the production tickets in parallel (tickets which are not dependent on Data warehouse Prod data validation activities which are in progress).
• Co-assisted the work stream and also provided the deliverables to the client on time.
• Involved in training the End users on how to use the tool.
• Involved with Query Optimization to increase the performance of the reports.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Used cascaded parameters to generate a report from two different Data Sets.
• Uploaded the reports to the Report Manager and organized them into folders.
• Used SQL server agent to schedule the reports.
• Extensively used all features of MS SQL Server2012/ 2008 R2/2008/2005 as a SQL Developer.
• Involved in writing effective queries for improving the performance of the SSRS reports.
• Created reports to retrieve data using Stored Procedures that accept parameters. And also converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of the reports.
• Designed the reports layout for creating tabular and matrix reports.
• Used prompts to generate Parameterized and Cascading Parameterized Reports allowing the user to limit the reports to particular cases and published the reports as PDF, Excel and CSV etc.
• Deployed the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report and gave roles, user access with respect to security in Report Manager.
• Good understanding of Data warehouse and ETL using Informatica.
• Good knowledge on Informatica Client tools.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Actively involved in Weekly Status Meetings.

Environment: MS SQL Server 2012/2008 R2, MS SQL Reporting Services, Business Intelligence Development Studio (BIDS), Report Builder 3.0, DB2 4.1.0.1 Client, MS Excel 2007, Windows 2007 Server.

Confidential, NY

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Created SQL Server Reports based on the requirements using SSRS 2012/2008.
• Identified and documented all the reports, tables (subject areas) and ETL for each Business units.
• Documented the current and Gap Analysis across all the business units for ETL, Reports and Data.
• Identified the underline reports tables which are touching non- replicated tables.
• Create Naming standards and Data dictionary for EDW Phase.
• Create the EDW server with project plan
• Participated in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment.
• Extensively used all features of MS SQL Server 2008 R2/2008 as a SQL Developer.
• Created Cubes with Dimensions and Facts and calculating measures and dimension members using Multidimensional expression (MDX).
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the data models.
• Created SQL objects like Tables, Stored Procedures, Functions, and User Defined Data-Types.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
• Widely used Informatica client tools -- Source Analyzer, Warehouse designer, Mapping designer, Transformation Developer and Informatica Work Flow Manager.
• Assisted in creating events and tasks in the work flows using workflow manager.
• Generated different reports using MS SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Involved in generating Matrix reports, Sub reports and Complex reports with multi value parameters using SSRS.
• Developed a Tabular Reports, Parameterized reports ad-hoc reports using SSRS Report Designer.
• Strong Experience in developing reports using Query Studio & Report Studio.
• Worked on designing and developing Data Warehouses, Data marts and Business Intelligence.
• Involved in using Informatica transformations for loading data from source to destination.
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Used complex queries involving join and union of multiple tables.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle).
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.

Environment: SQL Server 2012/2008 R2/2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2007, Oracle 9i, Performance Point Server 2007, Informatica 9.5.1, MS Excel.

Confidential, Cincinnati, Ohio

SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Installation and configuration of SQL Server Reporting Services (SSRS) 2008.
• Created Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports through SSRS and Report Builder
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports. (SSRS)(2005/2008).
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling
• Experience in moving the data from heterogeneous data sources like Oracle, XML etc to SQL using SSIS.
• Created subscriptions in SSRS to deliver reports to a shared file.
• Reports using SQL Server Reporting Services 2008
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Involved in migration of crystal reports to SSRS 2008.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSIS, SSRS), XML, MS PowerPoint, MS Access 2003 & UNIX, Oracle.

Confidential

SQL Developer

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Worked with SQL and PL/SQL to create Tables, Views, and triggers and stored Procedures.
• Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects.
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments.
• Involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2000.
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation.
• Created SQL Server Reports based on the requirements using SSRS 2000/2005.
• Involved in generating Dashboards, Sub-reports, parameterized reports based on requirements.
• Upgrade enhancements, maintenance, production support and bug fixing for the product.

Environment: T-SQL, SQL BI Suite (SSIS/SSRS) 2000/2005, Windows 2000 Server, Oracle.