SUMMARY:

• Over 8 years of excellent experience in IT industry as SQL Server developer/Business Intelligence developer, Database modeling, Design with Computer Science background and Financial, Banking and Entertainment domains experience .
• Good understanding of Enterprise Data Warehouse Architecture and worked with Senior architects to build advanced analytic platforms to ingest large streams of structured and unstructured data which minimizes the time to insight in a variety of areas using existing Data Warehouse, Cloud based server and service solutions (Amazon AWS/ Amazon Redshift /EC2) .
• Good experience on Confidential Big data stack, COSMOS and SCOPE languages
• Good Hands on experience dealing with On - Site/Offshore model and worked with Development, Production Support and Quality On-site/Offshore experience.
• Experience with third party controls tool kits like Telerik .
• Experience in solving issues related SharePoint Environment and SQL server.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Extensive experience in developing Stored Procedures, Views, Indexes, Triggers, Cursors, XML, Joins, user defined data types, functions and other Complex Queries on SQL Server 2005/2008
• Hands-on experience with Erwin Data Model Tool and strong knowledge of Relational Database Modeling/Loading and Dimensional database modeling concepts and star/snowflake Schemas implementation.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues .
• Excellent in High Level Design of ETL DTS Packages & 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 Migrated Database from SQL Server 2000 to 2005, 2005 to 2008 by using side by side migration .
• Developed Crystal Reports as per the client needs and maintain documentation of reports for future references.
• Expert in writing complex formulas in Crystal Reports, SQL queries using Crystal Designer, Crystal Dictionaries, and migration of Crystal Reports in different versions.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services 2008/2005, Crystal Reports and Excel spreadsheet .
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Experience in Managing Alerts, Operators and Jobs through SQL Server Agent and with SQL Mail .
• Data Modeling experience focusing on high-activity Normalized transaction systems ( OLTP ), highly-usable Renormalized Reporting Systems ( OLAP ) as well as staging areas and data marts.
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good knowledge of various mathematical modeling methods for financial derivatives and risk modeling, hedging .
• Delivered 24/7 support including scheduled and emergency night and weekend work.
• Can work in a fast-paced environment, Good team player and can work independently.

TECHNICAL SKILLS:

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, VB 6.0,Perl, CSS, HTML, XML, MHTML, JavaScript, ASP.Net

Databases: SQL Server 2012/ 2008/2005/2000/7.0, Oracle 9i/8.x, DB2, MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Data Stage, Import Export Data, Bulk Copy Program (BCP), FACETS.

Version Control: Team Foundation Server (TFS), Visual Source Safe (VSS)

Operating Systems: Windows / 98/2000/2003/ XP/Vista, Unix.

IDE & BI Tools: SQL Query Analyzer, SWIFT Tool, ERwin, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio (BIDS), Power Pivot.

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling, 1.1 using Rational Rose.

Other Software: MS Office 2007/2003/2000, Adobe Professional, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Sr SQL BI Developer

Responsibilities:

• Understanding the business requirements received from business team by taking part in triage meetings, and involve in database design, making enhancements to the existing database and SSAS cube.
• Working closely with Program Manager in BI team to analyze feasibility of requirements for pulling and processing of data.
• Designed various Scope Scripts in COSMOS to fetch data from structured streams and log files.
• Retrieving data from various sources by writing efficient stored procedures, functions, views, dynamic TSQL, and created ETL packages using SSIS 2012.
• End to end ownership of handling multiple service requests during busy periods with aggressive timelines.
• Complete automation of Extract and loading, processing, monitoring and maintenance of the system.
• Developed Dashboard reports using Power view and Power Pivot .
• Work on the Performance tuning of the database.
• Performed data conversions from flat files into a normalized database structure.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Configured mail tasks to know the job status of SSIS packages.
• Worked with Offshore team for ticketing issues, Development process and Quality support for various Subject areas.
• Created daily queries involving self joins, correlated sub-queries, CTE and XML techniques for diverse business requirement. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies
• Created databases, tables, stored procedures, indices, foreign keys and any other objects within the databases based on requirements from Developers
• Created SSIS Packages using SSIS Designer for export heterogeneous data from Access, Excel Spreadsheet to SQL Server 2008
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, Access, SQL Server 2005 and Flat files
• Worked on different kinds of Transformations in SSIS as per the client’s Requirement.
• Experience in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Provided 24x7 production support for the client's mission critical database environments.
• Provide ETL packages to support reporting which includes periodic data extract and refresh for OLAP database and Analysis Cubes.
• Development and Deploying of the reports using reporting services.
• Data Analytics to support current Data Quality Measurement and Reporting.
• Execute the ETL packages to extract the data on demand.
• Used excel connections to retrieve data from COSMOS to excel files and created adhoc reports based on them.
• Extracted data using Cosmos scripts from several virtual clusters and created adhoc reports.
• Deliver the requirement details to the off-shore team and review the code for accuracy.

Environment: MS SQL Server 2014, SSIS, SSAS, COSMOS, Visual studio 2013, Power Pivot in MS Office Excel, MS office 2016. Agile, Scrum, BIDS, OLTP, OLAP, T-SQL, HTML, Web Services, Excel VBA

Confidential,Renton,WA

MSBI / Data Warehouse Developer

Responsibilities:

• Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
• Loaded legacy source data from MSSQL , MySQL , Oracle , Access , and SQL Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import &Export Wizard and VB scripts, SQL Server Migration Assistant (SSMA) and SSIS packages.
• Created complex ETL logic for getting the data from log files present in cloud Amazon AWS into the ODS.
• ETL to Source data from Cloud based services (Amazon Web Services - AWS) and used containers and transformations to manipulate data, and to load transformed data into multiple data destinations in MS SQL Servers/Cloud based Data marts.
• Implemented highly-scalable Data Access Layer with a primary SQL Azure database and one SQL Azure database per customer/company.
• Implemented and deployed a system to Windows Azure, Confidential ’s new cloud solution.
• Also created complex ETL logic to get data from Splunk reports to ODS.
• Created TSQL stored procedures, functions, etc. and tuned them using query analyzer and explain plans. Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS Data Profiling Task, Data Profile viewer and T-SQL queries.
• Performed GAP Analysis on data mappings, and data element transformations.
• Used majority of the transformations, tasks, containers present in SSIS which include Derived Column, Conditional Split, Aggregate, Lookup, Row Count, Merge Join, Union All, Multicast, Sort, Copy column, Data conversion and other transformations during development.
• Participate in creating data conversion and migration strategy, conversion design and conversion development documents. Participate in Data Modeling Sessions. Hosted SSIS, SSRS knowledge transfer, data quality issue meetings with the client on a weekly/biweekly basis.
• Wrote T-SQL queries to validate the error reports being given to the client and prepared T-SQL scripts for the Application team, Reports team during development. T-SQL development included queries using joins, subqueries, ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF), constraints & Database triggers.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.
• Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS. Used dynamic connection managers using SSIS expressions to load data from 25 databases into a single DB.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis. Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.
• Conduct Code Walkthroughs, and perform SSIS/SSRS peer reviews.
• Used Perforce to check in code artifacts and Techno Solutions Top Team third party tool for process oriented tasks like assigning tasks, logging & assigning code defects, check in key decisions, documents etc.
• Developed data reconciliation SQL queries to validate the overall data migration. Prepared data reconciliation reports for conversion team/business. Maintained ETL functional specifications, test plans and data for data conversions. Automated the data reconciliation process to minimize the developer involvement in validating production migrations.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB, SIT, UAT, Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS and SSRS introduction material to the client.
• Worked with Managers to prepare requirements gathering documents and quality documents.

Environment: SSIS 2008/2012, BIDS, SQL Server 2008R2, T-SQL, XML, Confidential Project, Perforce, Amazon AWS, Splunk, Confidential Access, SSRS, Confidential Excel.

Confidential, NYC, NY

Sr SQL/SSIS Developer

Responsibilities:

• Bank has historical data feed files from different source systems/processors. The source data received from different source systems will be consumed by ETL routines using SSIS.
• Participated in meetings with all the members of the project to discuss, plan and implement strategies that would ensure all the business requirements reflect in the project development.
• Created SSIS packages for extract layer, Staging/Integration layer and Export layer.
• Worked on different kinds of Transformations in SSIS as per the client’s Requirement.
• Created Extract, Transform and Load ( ETL ) processes.
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.
• Participated in meetings with all the members of the project to discuss, plan and implement strategies that would ensure all the business requirements reflect in the project development.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses extraction, Transformation and the direction of data flow and Metadata using SSIS.
• Managed production support and defect/enhancement request tracking.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.

Environment: Confidential Sql server 2014, SSIS, BIDS, Notepad++, MS Visual Studio 2012, T-Sql, SQL Profiler, MS office 2013.

Confidential,Boston,MA

SQL BI Developer / Data Modeling/Analyst

Responsibilities:

• Created the Dimensional model for the General Ledger using the star schema model.
• Got the requirements from the business analyst for the audit and designed the dimensional model based on the inputs.
• Worked with team in meeting deadlines for the creation of database and tables and writing stored procedures, views.
• Involved in data modeling for the application and created ER diagram using Erwin .
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology .
• Created databases, tables, stored procedures, indices, foreign keys and any other objects within the databases based on requirements from Developers
• Wrote stored Procedure, scripts, cursors for the bulk application , tested them on the test servers and moved them to the production
• Created triggers to keep track of changes to the fields of tables when changes are made
• Strong experience with SQL Server performance tuning and optimization, query optimization, index tuning, caching and buffer tuning .
• Create a Confidential Access project and connect it to an existing Confidential SQL Server database
• Created web parts, workflows, info path forms and used SharePoint designer for master page creation.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from Access, OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008
• Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, Access, SQL Server 2008R2 and Flat files .
• Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services
• Involved in design and deployment of Report Models for generating Ad-Hoc reports as per the client requirements.
• Worked on different kinds of Transformations in SSIS as per the client’s Requirement.
• Created Extract, Transform and Load ( ETL ) processes.
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters.
• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Designed and developed SSIS packages to move data from production environment to different environments within the organization.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Worked with Offshore team for ticketing issues, Development process and Quality support for various Subject areas.

Environment: Agile, Scrum, Confidential SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services, Spotfire 5.0, Visual Studio 2008/2012(SSIS), SSRS, BIDS, HTML, Web Services, SQL Server 2008 Manager Studio, SQL Analyzer and Enterprise Manager and SQL Agent.

Confidential,Bellevue,WA

Sql server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Experienced in SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Big data aggregation using Cosmos scripts and developed adhoc reports based on them.
• Developed Scope scripts to read live data related to Contextual advertising from COSMOS (Big Data).
• Write code to extract data from the Cosmos data center using Scope on the Cosmos system, C#, batch files, T-SQL for the MS, aggregate data for forwarding to internal teams.
• Worked on various ad-hoc requests for extracting big data from Cosmos thru Scope scripting in Visual studio.
• Worked on ETL to implement the slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Worked with Managing the Offshore team for duties, time and milestone management for 24x7 support application.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server dynamic configurations for SSIS packages.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created views/indexed views consisting of computed columns to facilitate easy user interface.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column .
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Experienced in SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used SSIS, T-SQL Stored Procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Used BCP to transfer the data files to another server.
• Designed immaculate Database Structure as a data repository to host information from COSMOS (Big Data) to help analyze Yahoo publisher onboarding traffic.
• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
• Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using Sql Server Management Studio.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for creating reports based on the requirements using SSRS 2008.
• An expert in utilization of data flow items OLE DB sources for data source setups; Lookup component for finding existing rows on production; Derived column for adding load dates with in-built SSIS system variables; Multicasting for staging multiple copies of input data; Pivot for financial auditing; Conditional split for facilitating data routes based on various business rules; Data conversion for imported flat file data to be loaded with appropriate data types for SQL Server tables; Aggregate for enabling data aggregation such as SUM, Count, etc. and many more such as Character map, Merge and Merge join.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.

Environment: SQL server Reporting Services 2008, SSIS , COSMOS, Agile, Confidential Visual Studio, SQL Server Management Studio, MS Excel, Scrum, T-SQL, Red-Gate SQL Source Control, MS Visio 2008, SQL Profiler.

Confidential

SQL Server Developer

Responsibilities:

• Worked closely with BA, DBA to analyze business model, gather project requirement.
• Loaded and mapped data into Staging Database using SSIS packages.
• Performed data analysis for reports and presentations for senior management and external recipients.
• Populated data for Test environment.
• Developed, modified, and optimized very complex queries to data retrieval and modification
• Created alerts, notifications, and emails for scheduled SSIS packages execution.
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Migrated SQL server 2000 to SQL Server 2005 in Confidential Windows Server 2003 R2 Enterprise Edition SP2.
• Generated reports using SQL Server Reporting Services and Excel spreadsheet.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression ( CTE ).
• Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.
• Involved in migration of SQL Server 2000 databases to SQL Server 2005 databases.
• Supported Development UAT, System Test, Training, Staging and Production.
• Documented the procedures and process.

Environment: SQL Server 2005, SSIS, Packages, Windows Enterprise Server 2003, IIS Server, Oracle 9i, Informatica.