Professional Summary

• Over 7 years of experience as BI SQL Server Developer in the Design, Analysis, Development, Implementation, Testing, and Maintenance of application systems in Client Server environments.
• Good experience in MS SQL Server 2005/2008/2012, esp. Business Intelligent BI part, i.e. Reporting Services SSRS , Integration Services SSIS and Analysis Services SSAS .
• Experience in TSQL, ETL, SSRS and SSIS of MS SQL Server 2005/2008/2010/2012 product suit.
• Hands-on experience in gathering data for data warehouse from OLTP using SSIS
• Highly proficient in designing queries in accessing data and hands-on experience in query structuring, performance optimization using SQL Server 2005/2008 and 2010.
• Expert in Transact SQL Programming, query optimization and performance tuning using SQL profiler, Index tuning wizard, Performance Monitor and Execution plan.
• Proficient in scheduling and creating reports using SQL Server Agent.
• Data transformation services applications moving data between different types of databases and legacy systems.
• Experience in developing stored procedures, functions, triggers, views, optimizing queries, table normalization Proficient in handling Parameterized, Drill down, Drill through, Sub reports, Parameterized, Cascading and Chart reports using SQL Server Reporting services 2005 and 2008.
• Involved in all phases of Data ware housing life cycle and System Development Life Cycle.
• Very good knowledge of Relational and Dimensional database modeling concepts with Star schema and Snowflake schema's design and implementation.
• Experience in data modeling using Star schema identification of facts, measures and dimensions and Snowflake schema for designing a Data Warehouse using tools like Erwin and E-R Studio.
• Expertise in using Team Foundation Server TFS and Visual source safe VSS as a tool for repository of codes and version control, branching and merging in to production.
• Good understanding of Ralph Kimball theory. Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.
• Experience in Database Administration operations like Backup, Recovery, Import and Export and good knowledge of DDL and DML in TSQL.
• Extremely dedicated, hardworking, strong team player with an ability to take new roles. Excellent communication and strong analytical skills.

Technical Skills

Experience

Confidential

SSRS Developer

Responsibilities

• Designed and developed new reports for CVS new Incentive Medical products.
• Released different versions of Healthy Blue reports as per the user requirements.
• Created tabular and matrix report for the Healthy Blue projects.
• Created data loads and Upgrade scripts for data migrations and validations.
• Configured SQL mail agent for sending automatic emails when a DTS process fails or Success
• Worked on automating the SSRS work flows as per the day to day transactions.
• Worked closely with end users to understand the user requirements.
• Good understanding of database design and structure.
• Created a proposed solution document for the Atomization project.
• Involved in Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted to increase in performance of numerous modules.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager, uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etch

Environment

SSDT Data Tools 2012, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS,SSAS, T-SQL , SQL, MS Excel, MS Access, MS Visual Studio,.Net, Visio

Confidential

SSRS/SSIS/SSAS Developer

Responsibilities

• Designed and developed data migration process for migrating data from EDW to PWD using SSIS and SSRS services.
• Migrated crystal reports of EWD system to SSRS reports using reporting services, created sub-reports, multi-dimension reports and other tabular reports.
• Created migration process document for ETL and reports as part of on-boarding process.
• Created report layout guidelines document for report migration that enables QA to identity layout issues.
• Created multi-dimension reports involving cascading parameters in SSRS using SSAS cubes, dimension and measures.
• Worked on data mapping reporting issues involving EWD to PWD migration validating with data mapping and data mart sheet.
• Responsible for report deployment to both Dev and QA environments, also for reports fixed by off-shore development team.
• Involved in discussions with analysts and team leads for requirements gathering and analysis
• Used PVCS tracker for bug tracking, also involved in bug triage with QA lead team.
• Used Team Foundation Server for code, report and project management
• Created ER entity relationship diagrams using MS Visio tool

Environment

SSDT Data Tools 2012, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS,SSAS, T-SQL , SQL, MS Excel, MS Access, MS Visual Studio,.Net, Visio.

Confidential

BI SSIS/SSRS/SSAS /SQL

Responsibilities

• Experience in creating complex SSIS packages using control and data flow elements.
• Created ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Created data loads and Upgrade scripts for data migrations and validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
• Extensively used SSIS Import/Export Wizard to perform ETL operations
• Worked on SSRS to generate more than 60 reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Responsible to create dimensions with the cube wizard, refreshing cube to get the latest date updates, deployment of cubes to the production server.
• Used VISIO for database modeling.
• Implemented Unit Tests and Integration Tests.
• Prepared documentation related to database design, objects security and rules.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Created reports using SSRS from the cubes by connecting to SSAS
• Created joins and sub-queries for complex queries involving multiple tables.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Worked on T-SQL programming such as, stored procedures, user-defined functions, cursors, views and management of linked servers to Non-SQL-Server databases.
• Created functional and technical documents, report templates and reporting standards for the rest of team

Environment

SQL Server 2008R2, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SQL, MS Excel, MS Access, MS Visual Studio.Net, C , VB, Visio, XP professional.

Confidential

BI SSIS/SSAS / SQL

Responsibilities

• Responsible for creating reports based on requirements using SQL Server Reporting Services SSRS .
• Worked on mission-critical parts including ETL process using SQL Server Integration Services SSIS
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services SSIS packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database. Deployed the created reports into SharePoint and Report Manager, created data driven subscriptions for different users in desired format
• Experienced in migrating code from VSS to TFS.
• Extensively worked with Policy-Based Management i.e. Target, Facet ,Condition and Policy
• Created Report Models for developing ad-hoc reports by the end-users.
• Extensive experience working with Transactional and snapshot replications.
• Uploaded reports on to the report manager and organized them into folders.
• Involved in SSAS Cubes design by creating measure groups, dimensions, aggregations, Actions, Partitions and Perspective from huge dataset using SQL Server 2008 Analysis Services SSAS .
• Created Dimensions with the cube wizard and also individually.
• Refreshing the cube to get the latest information updated.
• Deployment of Cubes to the production server.
• Designed Star schema identification of facts, measures and dimensions and Snowflake schema.
• Created partition function, schema and file groups for fact tables.
• Implemented as a relational database with Web User Interface UI .
• Involved in Normalization to 3F for OLTP system and some De Normalization for OLAP system.
• Scheduled the DTS package for migration data from old system to MS SQL 2008. Reconciled data for transformation from SQL 2005 to SQL 2008 using SSIS.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources CSV files, oracle, and MS SQL 2000 and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment

MS SQL Server 2008R2,Windows Server 2008, DTS, T-SQL, SSIS, SSRS, SSAS, , PPS, C , ASP.NET, VB.NET, Erwin 4.0, ETL, Erwin, MS Access, XML, Excel, Visual Studio 2010.

Confidential

BI SSIS/SSRS SQL Developer

Responsibilities

• Involved in designing the physical databases model on SQL Server 2000 RDBMS using different Data Definition and Manipulation languages DML/DDL implementing constraints and triggers for data integrity in development database for personal banking system.
• Installed SQL Server 2005 with latest Service pack and established connectivity with the database created, configured and maintained database maintenance plans and also database backup and recovery.
• After installing the SQL server 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
• Import/Export and successfully migrated the Databases such as DB2 to SQL Server 2000 using DTS.
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Implemented Disaster Recovery plan using Log Shipping method.
• Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
• Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
• Performed optimization of query, triggers, and stored procedures, their testing focusing on stability and execution plan which has resulted up to 45 increase in performance of numerous modules.
• Designed new dynamic DTS Packages to transfer data between servers, load data into database and tuned the existing packages.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Developed complex TSQL code for the application.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Ensured developers coordinated their efforts in managing and maintaining different application databases.

Environment

DB2, SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, BizTalk Server2004, IIS 6.0, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service

Confidential

SQL Developer

Responsibilities

• Involved in requirement gathering, analysis, design, development, and deployment.
• Involved in designing ER diagrams and mapping the data into database objects.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages and wrote DTS scripts for data transfer.
• Configured SQL mail agent for sending automatic emails when a DTS process fails or succeeds.
• Involved in troubleshooting SQL Server database issues and maintain the server for maximum up time.
• Installation of service packs and security patches
• Creating and managing schema objects such as tables, views, cursors, indexes, procedures dynamically for any tables, triggers and maintained Referential Integrity
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them.
• Implemented Triggers and Stored Procedures to achieve the required functionalities.
• Used Performance Monitor and SQL Profiler to optimize queries and enhanced the performance of database servers.
• Used various tools to improve SQL Server performance like windows performance monitor and index tuning wizard.
• Involved in testing, bug fixing and documentation for the project.
• Used Crystal Reports and MS Access to write complex formulas and to query the database to generate different types of ad-hoc reports.
• Migration of schema and data from Development and Production server

Environment: MS SQL Server 2000, DTS, Crystal reports, .Net Framework1.1, C .NET, VSS, IIS 6.0, Windows XP

Confidential

Pune, India MS SQL Server Developer

Responsibilities:

• Created tables and define their relations by using foreign key and primary key concept.
• Involved in creating databases and developing stored procedures, Triggers, Functions, Views and SQL Joins using TSQL. Created reports using Excel for better understanding of database.
• Performed normalization of data base to reduce redundancy and achieve maximum system performance. Used query analyzer to optimize queries and developed database and even configured based on the present need.
• Provided effective work independently from specifications and with a diverse group of developers and end users to analyze business needs and translated that need into deliverables.
• Performed backup, restore and replication using import/export wizard for the physical database.
• Solved the problems by re-configuring parameters and did performance tuning to improve system performance.

Environment: MSQL Server 2008/2005, DTS, Windows 2003, SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Development Studio BIDS , SQL Server Query Analyzer, SSAS, ETL, Erwin, MS Visual Source Safe , FTP Communication, MS-Visual Studio