SUMMARY

• Over 6 Years of experience in analyzing, designing, tuning and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle(SDLC) using MS SQL Server 2012/2008R 2/2008/2005/2000 DTS/SQL Server Integration, Reporting & Analysis Services.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Strong experience with SQL Server and T-SQL in constructing complex stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, exceptional handling, and data integrity.
• Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• ETL implementation using SQL Server Integration Services (SSIS).
• Experience in creating and deploying SSIS Packages on high-activity, normalized transaction systems (OLTP), highly-usable denormalized reporting systems (OLAP) as well as staging areas and data marts
• Excellent in High Level Design of ETL DTS Packages& SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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.
• SQL Server OLAP database development including KPIs, Data mining, working with changing dimensions.
• ETL implementation using SQL Server Integration Services (SSIS).
• Thorough understanding of Kimball’s’ theory, KPIs, SQL Architecture.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Experience working on Data Aggregation and Storage design of cubes in SSAS.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP cubes
• Experience in using Performance Point Server.
• Excellent report creation skills using Microsoft SQL Reporting Services (SSRS).
• Worked on creating client reports and custom reports (On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using SQL Server Reporting Services 2005 and 2008.
• Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot table based on OLAP cubes which make use of multiple value selection in Parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS and ability to export reports and query results to Excel or PDF
• Experience in debug, maintenance of ETL packages and ETL optimization using SQL Server best practices.
• Expertise in OLTP/OLAP system study, Analysis and developing Database Schemas like star schema and snowflake schema used in relational, dimensional and multidimensional modeling.

TECHNICAL SKILLS

Database: SQL Server 2000, 2005, 2008, 2008 R2, Oracle

Operating Systems: Windows XP/2000/2003.

Programming Languages: T- SQL, PL/SQL, MDX

BI Suite: SSAS, SSIS, SSRS, PPS 2007/2010

ETL TOOLS: DTS, SSIS

Database Tools: SQL Profiler, Database Engine Tuning Advisor, SSMS.

VC Tools: Visual Source Safe, TFS, SVN.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SQL/SSIS/SSRS Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Troubleshooted the SSIS/SQL job Agent whenever necessary.
• CreatedSSISpackages to clean and load data to data warehouse.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and 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.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports andSSISpackages.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2008, SQL Server Business Intelligence Development Studio 2008, SSIS, SSRS, T-SQL, Performance Point Server, T-SQL, Visual Source Safe, SQL prompt.

Confidential, Atlanta, GA

SQL Server BI Developer (SSIS, SSAS and SSRS)

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Designed a dimensional model star schema using Microsoft Visio.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, INT, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent..
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Used Performance Point Server to create interactive reports with an ability to drill down into details.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2008, SSAS, SSIS, T-SQL, SSRS, MDX, Windows Server 2003, Oracle 9i, Performance Point Server 2010, Erwin, OLAP, OLTP.

Confidential, Evansville, IL

BI Developer/SQL Server Developer

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Worked with SQL and PLSQL 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
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Used informatica for ETL process.
• Extensive use of T-SQL DDL and DML commands for various applications.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting.
• Expert in implementing an extra level of security by creating views and creating stored procedures to query the confidential data.
• Increased performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Generated the various kinds of reports using Graphs and Images.
• Migrated some Crystal reports to SSRS reports
• Created Parameterized reports and linked reports using Bookmark links, Drill through links and Hyperlinks.

Environment: T-SQL, SQL Server 2008/2005, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.Net 2003, Erwin Data Modeler.

Confidential

Jr. SQL Server Developer

Responsibilities:

• Involved in configuring and converting MS SQL Server 2000 database to MS SQL Server 2005.
• Partially involved in Database design and Database objects.
• Created backups for databases.
• Partly Involved in Performance tuning.
• Created ActiveX DLL COM Components using Visual Basic 6.0.
• Responsible for Developing GUI Screens
• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Responsible for creating COM Components using ActiveX DLLs and for creating database and database objects like Tables, Stored Procedures, Views, Triggers, Rules and functions.
• Developed various management reports using Crystal reports 8.0.
• Maintain the application as per the user requirement.

Environment: SQL Server 2000/2005, ASP .Net, VB Script, Crystal Reports, Access, Excel