SUMMARY:

• Over 8 years of IT experience in system analysis, design, development and testing in various projects executed in MS SQL Server Developer 2012/2008/2005 in Industry verticals like Finance, Banking, Auditing and Supply Chain Management.
• Skilled professional with experience in all stages of SDLC: planning, analysis, design, implementation, and support.
• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Proficient in Installing SQL Server 2012/2008/2005 and configuration of their tools.
• Hands on experience in migration of database and SSIS packages from SQL Server 2005 to SQL Server 2008 and also from SQL Server 2008 to SQL Server 2012.
• Experience in RDBMS concepts and constructs.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions CTEs and Triggers to facilitate efficient data manipulation and data consistency.
• Excellent command of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility.
• Experience in Data Extraction, Transforming and Loading ETL between Homogenous and Heterogeneous System using SQL tools SSIS, DTS, Bulk Insert, and BCP .
• Experience in using tools like index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services SSAS .
• Experience in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Experience working with JD Edwards Enterprise One Financial Management such as. Accounts Payable, Accounts Receivable, Expense Management and General Ledger and Supply Chain logistics such as Inventory Management and Warehouse Management.
• Experience working with Oracle Suites such as Oracle Identity Management OIM and Oracle Identity and Access Management OIA .
• Expertise in financial markets products and processes such as Accounting, Fixed Income Trading and Settlement and Trade life Cycle Back office .
• Experience in designing Database Models using MS Visio and ER-Win.
• Expertise in generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Expert in creating drill down and drill through Report by passing parameters in SSRS and Crystal Reports.
• Good SQL Server Administration skills including backup recovery, database maintenance, user authorizations, Database creation, Tables, indexes.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduled DTS and SSIS Packages.
• Good Business and System analysis skills to understand the requirements and customize client application.
• Capable of quickly learning and delivering solutions as an individual and as part of a team.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Ability to learn new tools, concepts and environments.

TECHNICAL EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server Architect/ BI Architect

Barclays is a major global financial services provider engaged in retail banking, credit cards, corporate and investment banking and wealth and investment management, with an extensive international presence in Europe, the Americas, Africa and Asia.

Responsibilities:

• Provided architecture and technical lead / development for Business Intelligence Data Warehouse Application solution including design, architect and integration using SQL Server.
• Responsible for the entire project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Developed ETL packages with different data sources such as SQL Server, Flat Files, Excel source files, XML files etc. and loaded the data into target tables by performing different kinds of Control flow Transformations such as For Loop Container, For Each Loop Container, Execute package Task, Execute process Task, Script Tasks, Send Mail Task, Data Reader Task, XML Task and Data flow Transformations such as Lookup, Conditional Split, Derived Column, Audit, Merge, Merge Join, Sort using SQL Server Integration Services SSIS .
• Extensively worked with various data transformation techniques in SSIS by creating SQL scripts as well as C scripts Script Component Task , various data transformations and data flow tasks.
• Implemented Complex logic and used Partitioned Tables functionality for huge volumes of data.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Implemented a complete Architecture where we were reading data from multiple variable column flat files and loading them into our standard tables.
• Implemented SSIS package which used SFTP protocol to download files and then used them in feed Processing.
• Designed and Architect a complete solution where we were reading data from multiple databases like SQL Server, Oracle, DB2 and Sybase and loading them into our standard tables.
• Worked with multiple Active Directory and LDAP and wrote complex VB Scripts to get data from them on daily basis and updated underlying tables in SQL Server
• Wrote Complex PL SQL scripts to get data out of Oracle for Reporting purpose and load that into SQL Server Reporting Data warehouse.
• Designed dimensional model for SSAS Cube source database. Created SQL Views to implement STAR schema
• Designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server from different environments for the SSAS cubes.
• Implemented partitioned table approach for better performance and efficiency
• Implemented Change Data Capture CDC for key tables.
• Responsible for implementation of SSIS Logging, Error Configurations and Send Mail Task for error handling the packages.
• Assessed the existing architecture, identified gaps and implemented necessary changes to support the corporate vision, business model and requirements.
• Created batch jobs and used a scheduling tool AUTOSYS to set frequency
• Used Perforce for version control.
• Co-ordinate with Global Team based in London and Singapore and worked closely with them to implement this project.

Environment:

MS SQL Server 2008/2012, SSIS,SSRS,SSAS, T-SQL, Visual Studio 2008/2010, C .Net 2010, Oracle 10g/11g , PL SQL, Autosys, SQL Profiler, Erwin 7.x,Jira ,Perforce, SFTP FTP , Service Now , Crystal Reports.

Confidential

Sr. SQL Server Architect/ Developer

Responsibilities:

• Played a dynamic role during the requirements gathering, analyzing and designing of the database.
• Installed SQL Server 2008 and Management tools using SQL Server Setup Program
• Created new logical and physical database design to fit business requirements.
• Installed Oracle 10g client components and configured it to point to appropriate server.
• Engineered the SSIS architecture for new system keeping in mind the dynamic package Configuration using Environment variable and SQL server tables. Also took care of Error handling by creating a database that would have Error tables.
• Created a Template SSIS Package which uses Package configuration, Error Handling and Log files that would be used across the entire Project.
• Developed SSIS packages with different data sources such as SQL Server, Oracle, Flat Files, Excel files, HTML files and loaded the data into target tables by performing different kinds of Control flow Transformations such as For Loop Container, For Each Loop Container, Execute package Task, Execute process Task, Script Task and Send Mail Task and Data flow Transformations such as Lookup, Conditional Split, Derived Column, Audit, Merge, Merge Join, Sort using SQL Server Integration Services SSIS .
• Created a complex SSIS package to fetch the data from HTML reports using SSIS and then Scrub the data in staging tables using Stored Procedure and then feed the data into the SQL Server.
• Created SSIS packages to fetch the data from Oracle system and put them in Staging database and then doing massaging and scrubbing on data and feeding that data to SQL Server
• Responsible for Maintaining Test database up-to-date with data from Production system
• Created Runbook which includes step by step explanation of deploying the SSIS packages on the new server.
• Created and maintained all other documents related to project for instance mapping documentation, work flow documentation and configuration documentation.
• Co-ordinate with QA team in Dallas to help them in understanding the system and other aspects of the project.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Created useful user defined functions and multifaceted stored procedures for reporting purposes.

Environment:

MS SQL Server 2008, MS SQL Server Integration Services 2008 SSIS , MS Excel 2007, T-SQL, VB Script, MS Visio 2003/2007, Team Foundation Server 2008 , Oracle 10g/11g, Databus , HTML.

Confidential

Sr. SQL Server BI Developer/Architect

Armada Supply Chain Solutions provides a wide range of supply chain management services to the foodservice industry. At Armada, we work with industry-leading clients such as McDonalds, Darden, Boston Market, Chipotle to implement innovative supply chain solutions that reduce costs, maximize efficiencies and enhance service levels and reliability.

Responsibilities:

• Played a dynamic role during the requirements gathering, analyzing and designing of the database.
• Installed SQL Server 2005 and Management tools using SQL Server Setup Program.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2005.
• Developed ETL packages with different data sources such as SQL Server, Flat Files, Excel source files, XML files etc. and loaded the data into target tables by performing different kinds of Control flow Transformations such as For Loop Container, For Each Loop Container, Execute package Task, Execute process Task, Script Tasks, Send Mail Task, Data Reader Task, XML Task and Data flow Transformations such as Lookup, Conditional Split, Derived Column, Audit, Merge, Merge Join, Sort using SQL Server Integration Services SSIS .
• Developed SSIS packages to Migrate Data from Oracle Accounts Payable, Receivable, General Ledger into SQL SERVER 2005 for Monthly Reconciliation of General Ledger used in Cash Register Reporting.
• Developed SSIS packages to generate CSV Data feed from XML and load data into Oracle Accounts Payable and Accounts Receivable
• Tested, Cleansed and Standardized Data, meeting the business standards using Fuzzy /exact lookups.
• Extensively worked with various data transformation techniques in SSIS by creating SQL scripts as well as VB scripts Script Component Task , various data transformations and data flow tasks.
• Create complex scripts to do chucking and massaging of legacy data in staging area.
• Extensively worked with XML documents using XSLT, DTD, and XML Schemas XSD .
• Responsible for Maintaining Test database up-to-date with data from Production system
• Created a SQL Server Agent proxy account which uses a credential that lets SQL Server Agent run the job as the account that has the required permissions to resolve the issue related to Network files.
• Created log files dynamically to log errors in a text file. Checked before sending email if any error occurred then send log file as attachment with email if not then just send email stating successful completion of package using VB scripts.
• Created OLAP Cubes using Star Schema and Snowflake Schema.
• Created OLAP Databases and generated reports Using MS Excel.
• Created various report types like simple report, cross tab, sub report and drill through that cover the entire range of enterprise reporting requirements and distributed to Clients.
• Successfully implemented test environment for SQL Server 2008 and the BI tools of SQL Server 2008
• Created database maintenance plan to execute maintenance tasks including reorganize data and index pages and update database statistics.

Environment:

MS SQL Server 2005/2008, MS SQL Server Integration Services 2005/2008 SSIS , MS Excel 2003/2007, MS Access 2003/ 2007 T-SQL, VB Script, MS Visio 2003/2007, Tortoise SVN Subversion, JD EDWARDS , Red Prairie

Confidential

SQL Server BI Developer/Migration analyst

Responsibilities:

• Created database maintenance plan to execute maintenance tasks including reorganize data and index pages and update database statistic.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2005.
• Installed SQL Server 2005 and Management tools using SQL Server Setup Program.
• Created SSIS packages for the extracting, transforming and loading the data from SQL Server 2000 and flat files.
• Developed the SQL Server Integration Services SSIS packages to transform data from SQL 2000 to MS SQL 2005.
• Convert all existing DTS package of MS SQL 2000 to 2005 by adding extra SSIS task.
• Created complex SSIS Packages to perform filtering operations on daily basis for Back office Mainframe system data. The data comes through text files from Mainframe system and was loaded in to SQL server after scrubbing and Massaging using SSIS.
• Created complex SSIS packages to get the latest currency conversion from the website using WSDL and Web Service Task in SSIS.
• Responsible for creating batches scripts for implementing logical design to T-SQL.
• Responsible for creating database objects like table, views, store procedure, triggers etc to provide structure to store data and to maintain database efficiently.
• Created Views and Index Views to reduce database complexities for the end users.
• Perform T-SQL tuning and optimizing queries using SQL server 2005.
• Created indexed generic views to facilitate easy user interface implementation, security, and triggers on them to facilitate consistent data entry into the database.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the legacy databases to SQL server.
• Create complex scripts to do chucking and massaging of legacy data in staging area of SSIS package.
• Schedule Jobs to run SSIS package in night feed to DSS system for fresh day data.
• Wrote standard complex SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Created trace in SQL Profiler for Performance tuning on stored procedures and Scripts.
• Created demo reports for cash management system form old reports for validation of the data in new database.
• Modified old crystal reports by adding new business requirements using SSRS.
• Created useful user defined functions and multifaceted stored procedures for reporting purposes.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.
• Created Documentation for the packages and scripts and job created to migrate data from legacy system to SQL Server 2000.
• Run Import/export wizard to provide CSV and Excel files to mangers for the particular records they want for different meetings.
• Configure Report Manger and run reports on weekly and daily basis.

Environment:

SQL Server 2000/2005, SQL Server Integration Services, MS Visio, MS Excel 2003, MS Access 2003, Enterprise Manager, Management Studio, MS SQL Query Analyzer, SQL Profiler and SSRS and Crystal report 9.0.