SUMMARY

• SQL Server BI Developer with over 7 years of experience in the analysis, design development, implementing and testing, administrating client/server applications using Microsoft Technologies.
• Experience in installing and configuring SQL Server 2014/2012/2008 R 2/2008/2005/2000 SQL Server versions.
• Experience working in all phases of Software Development Life Cycle.
• Worked with Business Intelligence Development Studio (BIDS), which includes SSRS, SSIS, and SSAS.
• Experience in writing T - SQL, working on DTS, Data Cleansing, and Data Migration.
• Involved in migrating and upgrading SQL Server 2005 to SQL Server 2008.
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 11g, and OLE DB sources to various destinations by using SSIS 2008.
• Managed slowly changing dimensions (SCD) and optimized fact table inserts.
• Used DTS/SSIS packages and T-SQL stored procedures to transfer data from OLTP databases to staging area finally transfer into data marts.
• Experienced in implementing Dynamic ETL.
• Deployed several SSIS Packages using package configurations.
• Loading data into Dimensions and fact tables using SSIS.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS).
• Experience in developing reports using SQL Server Reporting Services (SSRS).
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Proven ability in generating Drill down and Drill through reports with Drop down menu options.
• Developed interactive reports using Crystal reports and SQL Server Reporting Services.
• Worked with Object Oriented Analysis and Design Concepts.
• Experienced in Data Extraction, Transforming and Loading (ETL) between homogenous and heterogeneous system using SQL tools like SSIS, Data Transformation and Services (DTS), Bulk Insert, BCP and XML.
• Experience in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Developed OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Experienced in tuning the reports that includes modifying, Testing the required T-SQL and MDX queries using DMV’s and creating the necessary environment for deployment.
• Great knowledge in Dimensional Modeling, applying Kimball’s methodology, Star Schema/ Snowflake Schemas, ODS. Experience in Performance Optimization of SSAS cubes.
• Wrote MDX queries and expressions in cubes for use in front end Business Intelligence applications.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation.
• A quick learner with an attitude for taking responsibilities.

TECHNICAL SKILLS

Languages: SQL, T- SQL, HTML, XML, C, C++, UNIX Shell Scripting

Databases: SQL Server 2014/2012/2008 R2/2005, MS Access, Oracle 11i/10g

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), MS Excel

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data

Testing: Unit Testing

Other Software: MS Office- 2013/2007/2003

Data Modeling: ERWIN, MS Visio

Operating Systems: Windows 2000/2003/XP/7

Database Tools: SQL Query Analyzer, Management Studio, SQL Server 2005/2008R2/2012, Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

SQL Server BI Developer

Responsibilities:

• Worked on full life cycle development (SDLC) involving all stages of development.
• Created database objects - schemas, tables, indexes, views, user defined functions, cursors, triggers, stored procedures, constraints and roles.
• Involved in installing and migrating legacy databases to SQL Server 2012.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Setup ETL jobs to run on a highly basis into the data marts using SQL Server Agent.
• Designed new dynamic SSIS packages to transfer data between servers, load data into the database and tuned the existing packages.
• Designed ETL packages dealing with different data sources (SQL Server, Excel files, and XMLs etc.) and loaded the data into the target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experienced in creating, testing, and implementing SSRS packages for reporting services that included paper-based and interactive web-based reports.
• Worked on building adhoc reports, parameterized reports, toggle reports, reports with sub reports using SSRS.
• Have written reports, sub reports, data driven subscriptions, drill down reports, using various features like charts, graphs, filters, etc.
• Created stored procedures to use as datasets for the report design.
• Used change data capture (CDC) functionality of SQL Server 2012 alongside SSIS to populate the destination tables with inserted, updated and deleted data.
• Developed highly complex SSIS packages using various tasks, containers, data transformations like Fuzzy Lookup, For Each loop, for loop sequence container, and FTP.
• Created SSIS packages for incremental loading, slowly changing dimensions, data importing, cleansing and parsing etc.
• Used SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2012, Visual Studio 2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Access, Oracle 11i.

Confidential, New Jersey

SQL Server BI Developer/SQL DBA

Responsibilities:

• Worked on all activities related to development, implementation, administration and support of ETL process for large-scale data warehouses using SSIS and DTS.
• Designed new dynamic SSIS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Used various transforms in SSIS to load data from flat files, XML, and Excel to SQL databases.
• Developed highly complex SSIS packages using various tasks, containers, data transformations like Fuzzy Lookup, For Each loop, For Loop Sequence Container, and FTP.
• Updated database statistics, re-indexed and fine-tuned of database objects and server. Extensively worked on DTA, DMV’s, Online Indexing, Data Partitioning and tuning of long running stored procedures and complex queries. Designed the data warehouse structure, data modeling and developed it using the Erwin tool, MS Visio.
• Worked on incremental loading, slowly changing dimensions, data importing, cleansing and parsing etc. using SSIS packages.
• Performed the tuning of some existing ETL. The process time was reduced from 8 hours to approximately 6 hours. This was 25% gain in performance.
• Backing up, restoring system and other databases as per our requirements, and also schedule those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Used SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.
• Involved in optimizing code and improved efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Provide 24/7production support for the production database and also to the code deployed into the production environment.

Environment: MS SQL Server 2008 R2/2005, VS2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence (BIDS), DTS, MS Visio, Erwin.

Confidential, New Jersey

MS SQL Server Developer/ MS Business Intelligence Developer

Responsibilities:

• Collated business requirements from users and translated them as technical specs and design docs for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Developed stored procedures, triggers, indexes, user defined functions, constraints, etc. on various database objects to 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 various features like data conversions etc.
• Created derived columns from the present column for the given requirements.
• Created complex ETL packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages and scheduled them as jobs to run automatically to process the cube, load data etc.
• Worked on BizTalk, MS SharePoint.
• 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.
• Developed, monitored and deployed SSIS packages.
• Responsible for scheduling jobs, alerting and maintaining SSIS packages.
• Developed different parameterized reports which consist of report criteria in various reports to make minimize the report execution time to limit the number of records required.
• 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).
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded into the audit table.
• Used Team Foundation Services (TFS 2010) to track the changes in code.
• Used environment variables to configure the SSIS package.

Environment: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, MS Excel, MS Windows Server 2003, BizTalk, Team Foundation Server 2010.

Confidential

SQL Developer/ BI Developer

Responsibilities:

• Developed system standards, system architecture, scenarios, detailed screen specifications and documented logical and physical data model.
• Implemented Type I, II changes in slowly changing dimension tables.
• Built physical data structures like tables, views, constraints and indexes.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2005 with high volumes of data.
• Implemented SSIS for various data transformation logic process.
• Maintained operators, categories, alerts, notifications, jobs, job steps, and schedules. Monitor connections, locks, and performance of SQL Server.
• Designed and built data load procedures using MS SQL Server.
• Configured product meta-data tables to support client data reporting needs.
• Built complexstored procedures for writing SSIS package logs into physical database.
• Worked with different methods of taking Database Backup and Recovery procedures.
• Generated database SQL scripts and deployed including installation and configuration. Worked on stored procedures and database triggers.
• Worked on large number of business analytic functions.
• Used SQL Profiler for troubleshooting, monitoring, optimizing of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Fine-tuned the logic in procedures, functions and triggers for optimum performance.
• Used Microsoft Source Safe for version control and configuration management.
• Tuning the performance database (SQL Profiler), query optimization and application tuning.
• Generated various reporting services RDL’s using reporting services for account aggregation reports.

Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T-SQL, DB2, Sybase, Active X, Microsoft Source safe, Windows 2003.