SUMMARY

• 8 years of in - depth experience in database design, development, administration and maintenance of SQL Server 2014/2012/2008/2008 R2/2005/2000 large scale databases.
• Hands on experience in installing, configuring, managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2012/2008/2005/2000.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Highly motivated SQL server Developer with eight Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and SSRS.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
• Worked Extensively on ETL process using SSIS package.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Excellent in creating 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.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Good understanding of Health care, Financial and Retail domains.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Experience in all phases of the Software Development Life Cycle (SDLC).
• Proficient in Conceptual, Logical and Physical Modeling
• Experienced with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
• Experienced in designing, developing and deploying SQL Server SSAS cubes.
• Experienced in database server performance tuning and optimization of Complex SQL queries.
• An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
• Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/ 2008/2008 R2/ 2012/2014, DB2, Oracle, MS Access

Database Tools: SSIS, SSAS, SSRS, Crystal Report, Power BI

Languages: VB.NET, C#, C++, Python, T-SQL, E-SQL

IDE: Visual Studio, Eclipse, MS Office, MS Project 2013

Operating Systems: Windows Server 2000, 2003, 2008, 2012

Case Tools: MS Visio, Erwin

Methodology: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

MS SQL Server (SSRS/SSIS/SSAS) / SQL Developer

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Developed Reports for business end users usingReport Builderwith updating Statistics.
• Updated functional specification and technical design documents.
• Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Designed SSAS cube for different business segment and created Calculated Measures using MDX and Tuned Cubes for better performance by deleting unused Aggregations by using Usage Based Optimization tool in SSAS.
• Performed Data modeling and Developed logical and physical model using Erwin and implementing them to SQL server.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS)
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Analytics / OLAP Cube Development (Microsoft SSAS)
• Power BI

Confidential

MS SQL Server (SSRS/SSIS/SSAS) / SQL Developer

Responsibilities:

• Requirements gathering, Analysis and Design of all the requirements.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Created SSIS packages using various data transformations like fuzzy lookup and derived column transformation to migrate the old database, activities and other important data.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Made various report parameters and query parameters to create parameterized reports using SSRS 2008.
• Designed, coded and implemented ad hoc reports using existing report models in SSRS.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using Variables, Expressions and Functions for the reports using SSRS.
• Optimized SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in testing, bug fixing and documentation for the project.

Confidential

MS SQL Server (SSRS/SSIS/SSAS) / BI Developer

Responsibilities:

• Gathered requirements about the project which was used to create the SSIS 2008 packages.
• Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008
• Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.
• Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Made various report parameters and query parameters to create parameterized reports using SSRS 2008.
• Performed complex Expressions to create calculated fields and used Global Variables in SSRS 2008.
• Created stylish reports and implemented conditional formatting using Crystal report.
• Successfully migrated MS Access data to SQL server 2008.
• Deployed and managed the reports in the Report Manager using SSRS 2008.
• Wrote complex stored procedure, views using T SQL in Management Studio
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.