SUMMARY

• Having 8 years of strong experience as a MS SQL Server Developer in various domains like Investment Banking and Healthcare with expertise in MS SQL Server 2012/2008/2005 , SSIS, SSRS and SSAS. Proven ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• Having both offshore and onsite experience with managing offshore software development teams.
• Highly proficient in using T - SQL, writing Stored Procedures, Triggers, Functions, Views and Cursors in SQL Server.
• Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012, 2008r2, 2005.
• Extensive experience creating complex packages for ETL purposes using various transformations in SSIS 2012, 2008, and 2005 as an ETL tool while transferring the data from various sources into the destination files.
• Transformed data from various data sources to SQL Server using BCP, DTS and SSIS 2012/2008.
• Creating the OLAP cubes using various dimensions and creating SQL Server Analysis Projects using SSAS 2008. Adept in defining referenced relationships and calculated members in SSAS, creating OLAP structures from OLTP databases.
• Hands-on experience with Relational database modeling and Dimensional database modeling concepts, Fact tables, Dimensions and star/snowflake schemas implementation.
• Extensive experience in Performance Tuning and Optimization of queries and stored procedures using DMVs, SQL Profiler, Execution Plan, Index Tuning Wizard and Performance Monitor.
• Experienced in all phases of project life cycle, starting from business requirement gathering and analysis to testing and deployment.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages
• Excellent experience in designing, maintaining & tuning various RDBMS like T-SQL & SQL Server 2012/2008/2005 , MS-Access databases.
• Experience in Developing and Extending SSAS Cubes, Dimensions, creating calculated measures, partitions, aggregations and Processing and Deploying SSAS objects and developing reports using MDX and SQL.
• Proficient in Migration of database, successfully migrated database from SQL Server 2005 to SQL 2008 and SQL 2008 to SQL 2012
• Successfully migrated content from DB2 to SQL server 2008, Oracle 10.g to SQL Server 2008.
• Involved in performance tuning of the queries in SQL server.
• Database management including backups, restores, updating statistics and rebuilding indexes.
• Good experience with Teradata utilities Fast Load, Multi Load, TPUMP, Fast Export and TPT Jobs.
• Good knowledge of Object Oriented Programming and .NET Framework 2.0/3.5, ASP.Net, C#, ADO.NET, MVC.
• Good knowledge in Web Technologies JavaScript, J-Query,Webservices, WCF, HTML, CSS and XML
• Comprehensive knowledge of Software Development Life Cycle, having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and implementation.
• 2 Years’ experience in Tableau Desktop & Server 9.x/8.x in analyzing and creating highly actionable and interactive reports and dashboards
• Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Having domain knowledge in Banking, investment management and Healthcare.

TECHNICAL SKILLS

• MS SQL Server 2012/ 2008r2/2008/2005
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Crystal Reports
• SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• XML
• ASP.NET
• C#
• VB.Net
• JavaScript
• HTML
• CSS
• J-Query
• MVC
• WCF
• Web services
• Tableau reporting tool
• Oracle
• Teradata
• Hadoop
• Hive
• Pig.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr MS SQL Server Developer/Team Lead (SSIS/SSRS/SSAS)

Responsibilities:

• Worked with Business users to understand the Business Logics as per the need
• Generated various reports like parameterized, drill down, drill through, sub reports using SQL Server Reporting Services (SSRS) for various projects
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Creating SSIS packages using C# scripting, script components and script tasks.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for extracting, cleaning, transforming and loading data into data warehouse
• Worked with DBAs in order to schedule SSIS packages as jobs either daily, weekly, monthly.
• Writing complex PL/SQL queries and designed SSIS packages to load the data into warehouse
• Design and develop OLAP cubes for Multi-dimensional data reporting using SSAS
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Migrating Crystal reports to SSRS
• Finding the root cause of a problem and then ensuring that it is resolved through the most appropriate solutions.

Environment: SQL Server, SSIS 2012, SSRS 2012, SSAS, PL/SQL, Asp.Net, C#, Tableau, Crystal Reports, TFS

Confidential, Dallas, TX

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Transformed complex business logic into Database design and maintaining it by usingSQLobjects like Stored Procedures, User Defined Functions, and Views.
• Successfully implemented indexes on tables for optimum performance.
• Use various SSIS transformations such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created ETL packages with different data sources (SQLServer, Flat files, Excel source files) and loaded the data into target tables by performing different kinds of transformations using SSIS 2008.
• Wrote MS SQL Server Store Procedures using existing Oracle logic.
• Worked on creating and maintaining Oracle objects such as Tables, views, and PL/SQL queries.
• Used SSMA for migrating data from Oracle to SQL Server.
• Involved in testing to compare and verify the result set in Oracle database and SQL Server.

Environment: SQL Server, SSIS, SSRS, DB2, T-SQL, Oracle and SSMS, MVC, Asp.Net, C#, J-Query, TFS

Confidential, Los Angeles, CA

MS SQL BI Developer

Responsibilities:

• Dealt with requirements gathering, analysis, design, development, change management, deployment and user training.
• Wrote complex T-SQL queries for various tasks such as functions, store procedure, triggers, cursors and various DML, DDL statements.
• Involved in writing dynamic SQL queries to accommodate changing data type and column names.
• Created, maintained, modified, and optimized SQL Server databases, database security and auditing
• Wrote various stored procedures, Indexed views, dimensions and stored outlines for optimal performance.
• Scheduled Jobs and Alerts, and scheduling SSIS package using SQL Server Agent.
• Connected Linked Servers to OLE DB data sources and providers.
• Evaluated database performance and performed maintenance duties such as tuning, backup, and restoration.
• Performed Data Analysis for automating various drugs related reports utilizing SQL Analysis Services.
• Produced operational reports in SSRS 2008r2 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.
• Designed, programmed, deployed and tested the requested Reports.
• Migrated DTS packages to SQL Server Integration Services (SSIS)

Environment: MS SQL Server 2008, SSIS, SSRS, PL/SQL, T-SQL, Asp.Net, C#, JavaScript, TFS

Confidential, Chicago, IL

MS SQL Server /SSIS / SSRS Developer

Responsibilities:

• Participated with business analysts in order to gather requirements for design and implementation of database.
• Worked on extracting, transforming and loading data using SSIS 2008 Import/Export Wizard.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Created local variables and global variables package configurations and error handling.
• Designed parameterized reports and ad-hoc reports using Report builder for the brokers and clients.
• Responsible for designing, creating and deploying the reports into the production server.
• Created complex store procedure to copy Database Objects from remote server to local machine and vice versa.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).
• Created complex Stored Procedures, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: SQL Server 2005, SSRS, SSIS, MS Access, MS Excel, BCP, T-SQL, Query analyzer, Visual studio, SVN

Confidential, DETROIT, MI

MS .Net / Crystal Reports Developer

Responsibilities:

• Involved in design, development and unit testing
• Involved in creation of database tables, writing stored procedures and views
• Involved in creation of User Controls and Master pages
• Used visual source safe for version control
• Generated few reports using Crystal Reports

Environment: MS .Net, ASP.Net, C#, AJAX, JavaScript, HTML, CSS, MS SQL Server 2005, Crystal Reports, VSS.