PROFESSIONAL SUMMARY:

• Over 7+ years of IT experience in Analysis, Database Design, Development, Implementation, Debugging and Testing of software applications to support Reporting and Business Intelligence initiatives.
• Strong experience in MS SQL Server 2008/2008R2 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility and automation with SSIS.
• Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling SSIS Packages.
• Worked with OLAP and Data warehouse application and worked with star schema, snowflakes schema dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.
• Expert in handling parameterized reports, formatting report layout, sub reports using global variables, expressions, functions, sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
• Worked extensively on designing and maintaining data cubes using ODBC to access data from heterogeneous databases.
• Expert in creating the cubes and dimensions (SSAS) and also hands on MDX.
• Worked in Data modeling, creating star and snowflake schemas in SSAS.
• Experience in developing the applications using T - SQL Programming (DDL, DML and DCL).
• Experience in creating and managing database objects like Tables, Views, Triggers, Cursors, Stored Procedures, user defined data types and Functions.
• Excellent T-SQL Programming skills. Experience in Performance Tuning and Query Optimization.
• Experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.
• Experienced in dealing with Relational Database Management Systems, including Normalization, Stored procedures, Check Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Excellent Analytical, Interpersonal and Communication skills.

TECHNICAL SKILLS:

Languages: T-SQL, VB.Net, ASP.Net, XML, HTML.

Tools /Utilities: SQL Server Management Studio(SSMS), Query AnalyzerBusiness Intelligence Development Studio, DTS, Analysis Manager, SQL ProfilerSSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus.

Databases: MS SQL Server 2008R 2/2008/2005/2000, Oracle10g, MS Access.

Tools: Microsoft Visio, UML & ER-WIN.

Software: MS Office, Adobe Adobe Photoshop.

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports, Business Objects.

WORK EXPERIENCE:

Confidential, Bethpage, NY

Sr. SSIS & SSRS Developer

Responsibilities:

• Translated business requirements onto technical designs to map and load data from source systems to the data warehouse.
• Created complex SSIS packages using proper control and data flow elements.
• Created packages in SSIS with error handling.
• Transformed data using Bulk Copy Program (BCP).
• Worked with event handler & log provider to logging in SSIS.
• Used SQL Profiler to optimize SSIS package queries and stored.
• Participated in enhancing processes for ETL design, source code control, integration testing, defect management, database standardization and tuning.
• Created Dynamic Drill-down, Drill- through, Toggle and filtering capabilities to provide insights into specific areas of interest.
• Experience in administration, creation reports and assigned permission to the valid users for executing the reports.
• Created and maintained SQL Server Agent jobs for automated processes.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS 2008 R2.
• Project is implemented following Scrum Methodology.

Environment: SQL Server 2008 R2, SSRS, SSIS, TFS, Business Intelligent Studio, SQL Server Management StudioT-SQL, ASP, Excel, Windows XP/2008 Server

Confidential, Rochester Hills, MI

Sr. SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Gathered business requirements from users and translated them as technical specs and design docs for developing Accounting Code Module.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) according requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc obtain the required results.
• Bulk data migration using SSIS from Flat Files & Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS by data conversion, derived columns etc.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS also deployed and monitored SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Migrated Reports from 2005 to 2008.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non queried parameters).
• Worked on all types of report types like Tablix, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc based on the requirement.
• Created pages in the reports to display based on the Prompt values.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Involved in creating Cubes using SQL Analysis Services (SSAS).
• Actively involved in Agile development methodology.

Environment: SQL Server 2008 & 2005, SSRS, SSIS, TFS, Business Intelligent Studio, SQL Server Management StudioT-SQL, MS Access 07, Excel, Windows XP/2008 Server

Confidential, Chicago, IL

Sr. MS SQL/BI Developer

Responsibilities:

• Used business requirements from users and translated them as technical specs and design documents for development.
• Designed/modified database schema objects & Created logical and physical data models using Erwin for new requirements as per discussion with technical team and application users as per agile methodology .
• Created Tables, Stored Procedures, Triggers, Views, Constraints and User Defined Functions and Optimized Stored Procedures.
• Created packages to transform heterogeneous data from different sources to the data warehouse using SSIS 2008.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from Excel Spreadsheet to SQL Server 2005 and SQL Server 2008.
• Created packages by using various transformations like SCD, Aggregation, Sort, Multi casting, Conditional Split, Derived columns, Lookup, Fuzzy Lookup, Fuzzy Grouping.
• Performed different task to map the data from the source to the destination tables with SSIS.
• Created various kinds of reports like parameterized, drill down, drill through and on demand sub reports and adhoc reports.
• Customized reports by adding new features such as report alerts, cross-tabs, running total, sub-reports and drill-down fields.
• Modified report content and exported reports in multiple formats based on user input.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Extensively involved in query optimization and performance tuning in Sql Server.
• Scheduled jobs to perform different action using SQL Server Agent.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions for SSIS Jobs and SSRS Reports.
• Involved in creating Cubes by using SSAS to analyze historical data and generated reports from it.

Environment: MS SQL Server 2008/2008 R2, T-SQL,VB.Net, .NET 2.0, Visual studio 2008, MS Access, Excel, SQL Profiler, Erwin, Microsoft VISIO, SSRS, SSIS, SSAS

Confidential, Boston, MA

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
• Migrated DTS packages to SSIS and replaced ActiveXscript task with necessary task in SSIS.
• Created package configuration using environment variables.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse Configured and maintained Report Manager and Report Server for SSRS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
• Published reports and dashboards on WEB.
• Develop and support OLAP, star schemas and cubes.
• Worked as a developer in creating complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Performance tuning, and optimization of procedures and queries.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution.
• Performed source/target analysis of data structures & content.

Environment: Windows 2003 Server/XP, DB2, SQL Server 2005, SQL Reporting, Business Intelligence StudioVisual Studio 2005

Confidential

Associate System Engineer

Responsibilities:

• Developed Stored Procedures to handle large amount of Data manipulation for Investment Banking financial factors.
• Involved in Development and Debugging and Enhancement of Complex Batch T- SQL Procedures and Functions.
• Worked on SQL Server Management Studio for Database Creation, Operations and Maintenance.
• Created several Complex Views according to the Client Requirements whenever needed.
• Extensively used Inner Joins, Outer Joins and Self Joins in Stored procedures.
• Very efficiently used Sub Queries and Cursors whenever they are required for increasing the Accuracy and Performance of the Queries.
• Worked extensively on documenting the Design Specifications.
• Worked in Importing and Cleansing of Data from various sources like DB2, Oracle, and Flat Files onto SQL Server 2000 with high volume data.
• Involved as a key team member for Requirement Analysis during the design phase and interaction with the client.
• Extensively Involved in Preparing Detailed Technical Documents from the Functional Specifications.
• Involved in day-to-day Database Maintenance Operations.
• Involved in Query Optimizations and Performance Tuning for the Stored Procedures.
• Designed and Developed Pivot Tables on Excel Sheets to refresh the data on timely basis.
• Established the Connection between Excel and Database to pull the data from Tables on to Excel Sheets from the Database to consolidate the data for Validation.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services.
• Generated various reporting service RDL’S using reporting services for Asset Allocation and Account Aggregation reports.

Environment: MS SQL Server 2000, T-SQL