SUMMARY

• A Technocrat with over 8+ years of experience as MS SQL Server Database Developer in Windows environment, current experience with SQL 2012/2008 R 2/2008/2005.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all phases of data warehousing development life cycle, from gathering requirements to testing, implementation and support.
• Experience in dealing with high volume transactional data in SQL.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Experience in design and development of Packages, Stored Procedures and Database Triggers using T - SQL. Experience in migration of SSRS reports from SQL 2000 to SQL 2005, SQL 2005 to SQL 2008.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Understanding of Dimensional Modeling, Forward/Reverse engineering, Software Testing and Quality Assurance activities.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Experienced in SSRS for report generation using XML and Excel spreadsheet.
• Experience in creating packages, Jobs, Sending Alerts using SQL Mail and Database Mail.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Ability to quickly grasp new concepts and apply software methodologies as per business needs.
• Team and Independent Player with excellent Organizational and Interpersonal skills. Excellent written and oral communication skills.

TECHNICAL SKILLS

SQL Server Tools: SSMS, Query Analyser, Export Import Wizard

ETL Tools: SSIS, SSRS, SSAS.

RDBMS: MS SQL Server 2005/2008/2008 R2/2012, MS Access.

Languages: Transact SQL, C, Visual Basic 6.0, C#, HTML.

Operating Systems: Windows95/98, Windows2000/NT/XP, Windows 7, MS DOS.

Reporting Tools: SSRS, Power Pivot, Report Builder, Cognos.

Other tools: MS Office (MS Access, MS Excel, MS PowerPoint).

Testing: Team foundation server (TFS), Bugzilla, Quality Center.

PROFESSIONAL EXPERIENCE

Confidential, White Plains NY

Data Analyst/ETL Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Interact with Stakeholders to identify, define and document business Requirements.
• Lead the UAT team for reconciling the Source to Submission reports.
• Worked on Corporate and Commercial AFS System for Submitting the FRY 14 Q Reporting.
• Have Implemented and Automated for the Complete FRY14 Q processing.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into Slowly Changing Dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into data warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Experience in developing reports using SSRS.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2005.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005/2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: Microsoft SSIS, SSRS, T- SQL

Confidential, Toccoa, GA

MSBI Developer

Responsibilities:

• Designed an automated framework for Credit reporting back to the Credit Bureaus to remain legally complied with Loan Finance system using SQL Server Integration Services.
• Extensively used SQL and SSIS to transform data and Dash boards as per the Business Requirements.
• Was part of the design architecture team for design and implementation of UDM.
• Implemented several Marketing strategies working with paid search companies.
• Designed and Implemented a Credit Monitoring using an algorithm. This helps the company to determine Loan Funding rules.
• Implemented several reports for RISK group which helps them to mitigate any risk.
• Effectively implemented logic reconciling ACH transactions provided by third party against our system to report accuracy.
• Loaded data into SQL Server tables from data sources like Flat files, Microsoft Excel and the Native client itself using SQL server Import & Export Wizard. I used this process whenever manual data load was required in lower environments DEV/SIT/QA/UAT.
• Configured the loading of data into Slowly Changing Dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Worked with Data Source team to understand the source data.
• Coordinated with Offshore team of 6 resources.
• Was part of my team to help succeed through all milestones.

Environment: Microsoft SSIS, SSRS, T- SQL, Excel, Power Pivot, SharePoint, C#, Team Foundation Server, Target Process, Report Builder.

Confidential, Redwood city, CA

SQL BI DEVELOPER

Responsibilities:

• Participated in sprint meetings to discuss on the present tasks assigned and any hurdles related to tasks.
• Interacted with business analysts and users to discuss the requirements for development.
• Developed technical specification document to assist in the design, development and/or maintenance of deliverables
• Created T-SQL queries for schemas, views, stored procedures, triggers and functions to migrate data from staging to production environment
• Modified existing stored procedures, functions using joins following SQL Standards to enhance the performance of the reports.
• Created SSIS Packages using several available transformation. to import the data into data ware house
• Developed SSIS script task, look up transformations and data flow tasks using T- SQL.
• Deployed packages to pre-production environment and created SQL Agent jobs to run those packages
• Implemented Logging and Error handling in SSIS packages
• Analyzed execution plan and optimized some complex queries by creating indexes and using some SQL best practices
• Created Parameterized, Cascaded parameter Reports using SSRS
• Created dashboard SSRS reports under report server projects and published SSRS reports to the reports server.
• Experienced in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008
• Developed, scheduled and generated various reports like List, Matrix, Drill-Down, Chart and Sub report and standardize company report by implementing SQL Server Reporting Services (SSRS)
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 R2 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users

Environment: SQL Server 2008 R2/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), .Net framework and TFS 2010

Confidential

ETL Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into Slowly Changing Dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Experience in developing reports using SSRS.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2005.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005/2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.