SUMMARY

• Over 7 years of experience in database analysis, database design and development in SQL 2012/2008/r2 in production and support environment.
• Experienced in implementing business logic using objects like tables, views, Cursors, stored procedures, roles, triggers and constraints using Data Definition Language (DDL) and Data Manipulation Language (DML) concepts.
• Expertise in BI applications reporting tool SQL Server reporting services (SSRS) and SQL Server integration services (SSIS).
• Achieved best performance for SQL& SSIS using synchronous Transformations, execution plan, Index tuning wizard and SQL profiler.
• Experienced in designing complex reports including sub reports and formulas with complex logic using SQL Server Reporting Services (SSRS).
• Worked on activities related to the development, implementation, administration and support of ETL processes for large - scale Data Warehouses using SQL Server SSIS
• Strong knowledge of Relational Database Management Systems (RDBMS) concept in several databases like SQL Server 2012/2008/r2 and Oracle 11g/10g/9i.
• Experienced in data import/export, data migration between homogenous system using Data Transformation Service (DTS) Packages, Bulk Copy command (BCP) and Bulk Insert.
• Proficient in Designing and Documentation of SQL Server Strategies and plans.
• Conversant with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation using Water fall model and Agile methodology.
• Generated Crystal Reports, MS Data Reports using different Reporting tools.
• Thorough Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.
• Hands on experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduling SSIS Packages.
• Expertise in Deployment of SSIS packages using deployment utility, and SQL server.
• Having knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
• Strong experience in data transfer from Oracle 8i/8.0, and MS Access to MS SQL Server 2005 using ETL tools like SSIS and MS DTS.
• Provided 24x7 support and trouble shoot production issues on high availability systems.
• Excellent team player and efficient in handling multiple project priorities with outstanding communication, presentation, interpersonal skills and good work ethics.

TECHNICAL SKILLS

Databases: MS SQL Server, PostgreSQL, MS Access

MS SQL Server: SSIS, SSRS

Data Virtualization: Denodo Platform 7.0

Authentication: LDAP, Kerberos, OAuth 2.0

Programming: Python

Visualizations: Tableau, Seaborn, Matplotlib

Big Data: Hive, Spark, Oozie

AWS: EC2, RDS, Redis, S3

TECHNICAL SKILLS

Confidential, Houston

MS SSIS/SSRS/ SQL Server Developer

Responsibilities:

• Captured requirements from Business & Systems Analysts and business users, documenting them as detailed statements and requirements to be used for design and development of code.
• Implemented SSIS packages for the exchange of data between different data sources.
• Successfully migrated data from multiple environments into SQL Server 2012/2014 using SSIS.
• Expertise in solving any issues related SharePoint Environment and SQL server.
• Extensively worked Shared Services Function such as Managed Properties, Content Sources, and Crawling.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data and extracting data from multiple data sources perform multiple complex transformations and land data into SQL Server Tables.
• Wrote complex stored procedures for report development.
• Generated reports using SQL Server Reporting Services 2012 (SSRS).
• Creating and maintaining database objects like Tables, Indexes, Stored Procedures, and Views.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports.
• Integrated TFS with SQL data tools to manage MSBI stack packages properly in DEV, QA and PROD environments using check in and checkout and have maintained history for every minor change.
• Performed Database consistency checks with DBCC, Index tuning and monitored error logs
• Optimized the performance of complex source queries and stored procs with the help of execution plan and Database Engine Tuning Advisor to fetch data fast from source systems
• Developed Cross-Tab and Sub reports in SSRS 2012/2014.
• Documentation for all kinds of reports and SSIS packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created stored procedures for maintaining SQL Server, Analyzed Stored Procedures for Application Developers.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Environment: SQL Server Integration Services 2012/2014 (SSIS), SSRS 2012/2014, SQL Server Management Studio, Tableau, Denodo

Confidential, Dallas, Texas

MS SSIS/SSRS/ SQL Server Developer

Responsibilities:

• Expertise in solving any issues related SharePoint Environment and SQL server.
• Wrote complex stored procedures for report development.
• Creating and maintaining database objects like Tables, Indexes, Stored Procedures, and Views.
• Involved in the complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Worked with business users to gather the requirements and documented the specifications of reports and distributed among the developers.
• Extensively worked on stored procedures, functions in T-SQL.
• Used Tabular and Matrix Reports Layout to design reports, based on the requirement.
• Worked on SSRS extensively to create and design reports.
• Worked with Report Builder, and Power Pivot to build Ad-hoc Reports.
• Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Created reports using multiple data sources.
• Scheduled the SSRS reports in Report Manager to run every day, weekly and monthly.
• Subscribed the reports to deliver them using an email.
• Managed the security in Report Manager.
• Used Team Foundation Server for version control.
• Extracted the data from source (FTP) and transformed to meet the user’s requirement.
• Designed SSIS Packages using several transformations to perform data cleansing and data transformation.
• Created SSIS Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Trained users on how to use SSRS reports.
• Attended functional testing and user acceptance sessions and worked on the feedback provided by them.
• Communicated with business and end users to analyze and documenting the requirements.
• Created detailed documentation of data warehouse, data marts, reports, ETL and other.

Environment: SQL Server Integration Services 2012 (SSIS), SSRS 2012, SQL Server Management Studio 2012, Visual Studio 2010, Microsoft Office, Power Pivot, TFS 2010, Windows7

Confidential

MS SQL Server Developer/BI/ETL Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the public data collected.
• Participated in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
• Creating Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Creating and integrating User Defined Functions and Stored Procedures for reporting purpose.
• Developed Ad-Hoc reports, sub reports, drill down reports, parameterized reports and dirty reports.
• Using various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Designing and testing (Unit, Integration and Regression) packages to extract, transform and load data using (SSIS)
• Designing packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLEDB Command and Derived Column.
• Moving the entire phase from the Staging to the Production.
• Fine tuning of database objects and server.
• Job Monitoring and making sure all jobs run successfully every night.
• Creating reports using the Crystal Reports and publishing them on the server.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Windows XP, IBM DB2, Tableau, XP2, Microsoft Office 2003, Microsoft Outlook.