SUMMARY

• Around 5 years of experience of Business Intelligence Experience including BIDS (Business Intelligent Development Studio, Data Tools) MS SQL server 2000/ SQL Server 2005/ SQL Server 2008 R2/ SQL Server 2012, SQL Server 2014, SQL Server 2016, SSIS, SSRS, Transact SQL, Data Warehousing, SSRS Report Writing and ETL strategies. Also other reporting tools such as Tableau and Power BI
• Involved in pulling data from heterogeneous sources such as DB2, Oracle, Excel, Flat files to SQL Server using SSIS Development Studio (or Data Tools).
• Familiar with new features of SQL Server 2012 and SQL Server 2016 (Data Tools), including column stored indexes and temporal tables.
• Used ER - Win and MS Visio Data modeling tools to design and implement Logical and Physical models of various Relational Databases.
• Involved in Forward and Reverse Engineering Data models between ER-Win and Microsoft SQL server RDBMS.
• Proficient in writing Transact SQL queries that perform both DDL and DML operations involving creation of Tables, Views, Indexes, instead Of and After triggers, File groups, Partitions, performing inserts, updates, deletes using Joins, Sub queries, and adding constraints on the tables.
• Developed advanced queries and processes to aid or improve existing processes.
• Experience with process automation, data integrity, and adherence to business rule requirements for tuning of existing processes.
• Familiar with code versioning tools such as Tortoise SVN and Team Foundation Server (TFS).
• Collaborated with different department managers in order to ensure that requirements are understood.
• Excellent experience in creating Master-Child Packages in SQL Server Integration Services (SSIS) and using configurations to deploy from Staging to QA to Production environments.
• Experience in Visualization Tools such as Tableau and creating data extracts for other Tableau developers.
• Used control flow, data flow, Event handlers, setting up mailing tasks and management tasks in SSIS.
• Managed various SSIS Package Configurations in the form of XML Files, SQL tables and deployed packages from development server to testing and testing to production environments using Deployment Utility.
• Developed maintenance plans like back up databases, check database integrity task and execute SQL Server Agent Job etc., on the Data Warehouses.
• Involved in modeling facts and dimensions in Data Warehouses in both Star-Schema and Snowflake Schema.
• Excellent Interpersonal, Analytical and Communication skills.
• Self learned skills in C++ language in a fast paced workplace. I specifically learned it during a solo project with no background in C++ previously.

TECHNICAL SKILLS

Languages: T-SQL, Dynamic SQL, XML, HTML, HTTP.

RDBMS: SQL Server 2016/2012/2008/2005/2000 , MS Team Foundation Server (TFS), and MS Access 2003/2007/97 , Excel 2007, 2010

Database Design Tools and Data modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, Physical & logical data modeling, Normalization and De-normalization techniques. TSQL Query optimization.

BI Tool: SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SSRS, SSAS, Visual Studio 2005/2008/2010 , Data Tools

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Database Developer/Report Writer

Responsibilities:

• Involved in gathering requirements for SSRS and Tableu reports
• Automated several daily tasks that were time consuming for the team prior to me arriving.
• Created stored procedures from scratch based on recurring reports requirements set by customers.
• Involved in rewriting existing code in order make use of new database objects such as newly introduced tables or functions.
• Met with business people in order to fulfill the customized requirements for each individual client.

Confidential, CA

SSIS Developer/ Database Developer

Responsibilities:

• Created Stored Procedures from scratch according to the requirements given to us solely via email.
• Developed SSIS packages that used the same stored procedures in order to automate jobs to run weekly, monthly, or yearly.
• Created .bat files that executed specific packages, which used parent child package logic in order to reduce redundancy of packages by allowing the parent package to pass changing variable values to the child.
• Involved in optimizing packages by enabling parallelism of the tasks used and by observing the overall dynamics of the package.
• Met with business people in order to fulfill the customized requirements for each individual client.
• Lightly coded logic in C++ inside the Script Task component in SSIS in order to access Remote FTP, perform logic, and push out files according to that logic.

Confidential, CA

Database/SSIS Developer

Responsibilities:

• Created ETL Process to pull the appropriate data needed for reports that served the marketing and finance departments. In addition, managed various SSIS Package Configurations in the form of XML Files, SQL tables and deployed packages from development server to testing and testing to production environments using both Project AND Package Deployment methods.
• Met with multiple stakeholders weekly in order to make sure that the requirements were well defined and clear to my team.
• Facilitated the tracking of historical records using complex Merge Statements for the enterprise data warehouse.
• Created end to end process for delivering reports including ETL, data driven subscriptions, ultimately to have the SSRS report delivered in multiple formats to different people from the organization depending on specific internal business rules.
• Worked independently on several large projects that were dead line driven and also helped the team with peer code reviews in order to ensure high quality code went into production.

Confidential, San Diego, CA

TSQL/SSIS Developer

Responsibilities:

• Extensively used Stored Procedures, Queries and Triggers for performing ETL
• Extensively used SSIS Packages for performing ETL
• Experienced with Relational and Dimensional models using fact and dimension tables
• Created various types of reports such as Parameterized reports, Drill Down reports, Linked reports using SQL server Reporting Services
• Involved in meeting with stakeholders and managers about the project requirements and gathering the requirements while asking questions to help my team and I understand what is being developed with the sole aim to have quality without any development hours being wasted.
• Worked closely with senior management, subject matter experts and IT teams to define business requirements and translate them into technical functional requirements for the development team.
• Worked on all the activities related to the development, implementation, administration and support of ETL processes for data warehouses using SSIS, DTS, stored procedures and BCP and Bulk Insert to load data from flat files into SQL Server when we were too lazy to create a package for it in SSIS.
• Managed and tracked requirements/changes in an organized way with the aim of development progress being n schedule.
• Enhanced the logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2012.

Confidential, San Francisco CA

Business Intelligence Developer

Responsibilities:

• Filtered, purged and cleansed dirty data from legacy system using complex T-SQL statements in staging area, and implemented various constraints and triggers for data consistency.
• Successfully migrated old data from legacy systems and external system including DB2, excel and oracle into SQL Server 2005 using SSIS complex packages.
• Optimized complex queries and stored procedures, identified, tested, and resolved database issues.
• Responsible for the Database modeling of the systems (physical and logical).
• Created database objects like Procedures, Functions, Triggers, Indexes and index Views using T-SQL to create complex scripts and batches.