SUMMARY

• Having 7+ years of extensive experience in IT industry as SQL Developer in MS SQL Server 2008R 2/2008/2005/2000 in Production, Quality & Development environments.
• Worked on Software Development Life Cycle (SDLC), data modeling, business analysis, and data warehouse.
• Professional experience in the MS BI stack: Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Expertise in developing Transact - SQL scripts for reuse in normalizing incoming files along with creating SQL queries.
• Expert in creating Database Objects - Schemas, Tables, Indexes (clustered and non clustered), Views, User defined functions (UDFs), Cursors, Triggers, Stored Procedure,
• Efficient in building recursive queries using CTEs (Common Table Expressions).
• Experience in ETL (Extraction, Transformation and Loading) using Data transfer services (DTS), Service Broker and SQL Server Integrated Services (SSIS) from various Data sources.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• 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). SQL server 2000/ 2005/2008 R2, Oracle 8i/ 9i/ 10g, DB2 and Teradata.
• Experience in query optimization (SQL tuning) using SQL Profiler, Database Tuning Advisor (DTA), Index tuning wizard and Performance monitor for performance tuning.
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experience in developing, configuring and deploying the SSIS packages and providing security for the packages.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Expertise in managing project versions and source code changes using source control tools like Visual source safe.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Expert in creating SQL Reports using SSRS and defining queries for generating drill down reports and embedding then into web services in .Net.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Expertise in Database driven web based application developer: using SQL Server 2000, MS Access, Visual SourceSafe, MS SharePoint, MS FrontPage.
• Worked on administration tasks such as data loading, batch jobs, configuring IIS, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups/files/transaction logs.

TECHNICAL SKILLS

SQL Server/BI Tools: SQL Profiler, Query Analyzer, BIDS, Export & Import (DTS), SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), MSSQL Server Integration Services 2008R2/2008/2005 (SSIS), Data Transformation Services(DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP).

Languages: C, C++,C#.NET,VB.NET, PL/SQL, T-SQL, Oracle 8i/9i/10g/11g, ADO.NET

Data Modeling Tools: Visual Studio 2005/2008/2010 , Erwin 7.2, MS Visio 2003/2007, Rational Rose

Reporting Tools: BIDS, Report Builder 2.0, Crystal Reports, SQL Reporting Services and Actuate E-Reporting.

Application Packages: MS Office, MOSS 2007, PPS 2007

Operating Systems: Windows 2000/NT/XP, UNIX, Windows Server 2003/2008

Architecture: RDBMS, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, OR

MS SQL Server/ SSIS/SSRS

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions) for Confidential ever changing complex financial business requirements.
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check and Unique etc). Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• I’ve extensively used SSMS for creating partitions in tables, ranking tables, writing nested queries, creating indexes, and cursors.
• Performance-tuned existing stored procedures with severe efficiency issues, making them more user friendly and run smother.
• I’ve addressed bugs and fixes for Stored Procedures that were involved in updating and processing 3 to 10 millions of records every week..
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Created SQL scripts for tuning and scheduling.
• Performed data conversion from flat file into a normalized database structure.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to Data warehouse.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and Involved in extracting the data using SSIS from OLTP to OLAP.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration of SSIS packages with Business Intelligence development studio.
• Generated reports using SSRS and Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Creating the reports based on the requirements using SSRS 2008.
• I reverse engineered and created Functional Specifications on business logic for Client’s documentation.

Environment: MS SQL Server 2008, SSIS, SSRS, BIDS, C#, Visual studio 2008, MS Visio 2007 and XML. SQL Server Query Analyzer, SQL Profiler, TFS, Net Framework, Silver Light Tools

Confidential - TX

MS SQL Server / SSIS/SSRS Developer

Responsibilities:

• Create newSSISpackage to extract date from Oracle to SQL Server using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Developed, monitored and deployedSSISpackages.
• Performance tuning ofStored ProceduresandT-SQL Queries.
• Createdindexeson selective columns to speed up queries and analyses in SQL Server Management Studio.
• UsedExecution Plan,SQL Server Profilerto trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Did error logging usingEvent handlersandTry catch blocksfor various packages
• Extensively worked withSSIStool suite likeConditional Split,Lookup,MulticastandDerived Column.
• Developed several Tables, Stored Procedures, functions and views to load data from the SQL server
• Working very closely with other developers for their SQL requirements, work with Business Analyst and end users to understand the report requirements.
• Performance Tuning already existing queries to improve the query time for faster reports.
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, Drill through etc..) using SSRS.
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc
• Discussed business requirements and mapped business needs. Used Query for ad hoc Reports and Users design Custom Queries. Analyzed reports and fixed bugs in stored procedures.
• Interacted with end users to gather requirements to create technical and users documentations

Environment: MS SQL Server SQL server 2005/2008, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, SSAS,SSRS, TFS

Confidential, MD

MS SQL Server / SSIS/SSAS/SSRS Developer

Responsibilities:

• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
• Used various transforms in SSIS to load data from flat files, Siebel CRM and FTP to the SQL databases.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Created Grouping, Sorting columns and writing expressions according to the business requirements.
• Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.
• Involved in developing Data Access Components to access the SQL Server Database using ADO.NET.
• Created Cross-Tab, Drill-down, Drill-through and Sub drill down reports -Report using RDL. Promoted RDLs to Reporting Service Server.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Created parameterized and drill through reports in Cognos Report Studio.
• Created Data warehouse Cubes inSQL Server Analysis Service (SSAS).

Environment: SQL server 2008 on Windows 2003 server, IIS, Visual Studio, SSIS, SSAS, SSRS, Database Mirroring, Replication, Log shipping, Cognos Report Studio, Framework Manager, BIDS and SSMS.

Confidential, Houston, TX

MS SQL Server / SSAS/SSRS Developer

Responsibilities:

• Created reports on SQL server reporting services 2005.
• Built reports through Report Builder and Report Designer.
• Created reports using Report Model and applying row level security filters.
• Studied the existing OLTP system(s) and created facts, dimensions and star schema representation for the data mart.
• Designed and developed OLAP Cubes in SSAS.
• Integrated SQL Server 2005 Reporting Services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point Portal (SSRS).
• Worked on PROCLARITY to create cost effective reporting and analytical solution.
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Designed, built the dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Worked on Cube structure optimization for MDX query performance in Analysis Services 2005(SSAS).
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Migrated DTS packages from SQL Server and scheduled their execution time.
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
• Used T-SQL for creating stored procedures, indexes, cursors and function.

Environment: MS SQL Server 2000/6.5/7.0 , T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler, SSAS, SSRS

Confidential, PA

MS SQL Server / SSIS/SSRS Developer

Responsibilities:

• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP
• Involved in gathering and analyzing user requirements.
• Created Stored Procedures, Triggers, Tables, Views and Functions for the Application.
• Developed complex T-SQL code for the application conversions.
• Involved in developing Data Access Components to access the SQL Server Database using ADO.NET.
• Took over the responsibility in implementation and documentation required to ensure that million records were accurately migrated.
• Created more than 150 packages and loaded data into destination.
• Validated the data coming from various source systems and loaded into target tables.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Performed daily back up of entire database and recovery. Responsible for creating the reports basing on the requirements using SSRS 2008.
• Generated the reports by using SSRS.
• Created functional and technical specifications for projects.

Environment: Windows 2003 Server Edition, SQL server 2005, MS-Access 2000 and IIS, Enterprise Manager, SQL Server Integration Services(SSIS), VB.Net, Visual Studio 2005, MS Reporting Services(SSRS), Testing.

Confidential, Columbia, MD

MS SQL Server / SSIS/SSRS Developer

Responsibilities:

• Responsible for working with co-developers in designing packages in SSIS/SSRS.
• Worked on Clinical, Medicare and Financials reports and packages.
• Developed several Tables, Stored Procedures, functions and views to load data from the OLTP database.
• Created SSIS packages for Uploading of Various different format of files (Excel, Access, dbf).
• Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
• Working very closely with other developers for their SQL requirements, work with Business Analyst and end users to understand the report requirements.
• Performance Tuning already existing queries to improve the query time for faster reports.
• Created several Complex Reports (sub reports, graphical, drilldown, Drill Through, Etc..)
• Developed Stored Procedures and Views to be used to supply the Data to the Reports. Complex formulas were used to show derived fields and to format the data based on specific conditions.
• Developed various Charts and Graphs like bar charts, line charts, pie charts etc by using chart experts.
• Discussed business requirements and mapped business needs. Used Query for ad hoc Reports and Users design Custom Queries. Analyzed reports and fixed bugs in stored procedures.
• Deploying SSRS and SSIS packages to the development server and MKS.
• Interacted with end users to gather requirements to create technical and users documentations

Environment: SSRS, SSIS, BIDS, SQL Server 2005, MKS.

Confidential

SQL Server Developer

Responsibilities:

• Gathered functional requirements and Business requirements and written the technical specifications.
• Created database objects like tables, indexed views, indexes, stored-procedures, triggers and cursors using DDL, DML statements.
• Developed stored procedures and views for managing efficient data retrieval and application development.
• Wrote stored procedures for querying the data dynamically by defining parameters.
• Extensively used reporting tool (Web focus) to create reports as per user requirements.
• Created reports out of the views and developed OLAP cubes.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Used DTS Packages for data import and export data from SQL Server to MS Access, flat files and EXCEL files.
• Performed some DBA Tasks like checking the jobs, data consistency and troubleshooting the issues.
• Worked closely with developers, end users and Administrator in designing and developing database.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Responsible for enhancements and Maintenance of the product.
• Optimized SQL statements for customer summary reports.
• Developed the data warehouse to design the business process data representation, dimensions and fact tables using SQL Analysis services.
• Extensively worked on star schema and snowflake schema.
• Prepared the detailed project layout, analyzed existing technology involved, and documented work performed and stored in VSS.

Environment: SQL Server 2000 Enterprise Edition, Microsoft Analysis Services, SQL Server Reporting Services, SQL Enterprise Manager, DTS, Erwin 4.1, Windows XP, MS Access, MS Excel, HTML.