SUMMARY

• Around 6 years of Excellent Experience as SQL Server Developer in Production, Development, Testing environments with various domains like Health Care, Financialand Insurance Telecommunications.
• Experience in SQL Server 2000/2005/2008 , SQL, T - SQL, Stored Procedures, Triggers, UDF, BCP, DTS, SSIS packages, and Oracle 9i/10 g, PL/SQL, SQL Plus, Oracle Developer 2000 Forms and Reports.
• Skilled in data warehousing tools, data mapping, unit testing, migration, conversions, and process documentation
• Proficient in developing Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Ad-hoc reports using Business Objects.
• Good noledge in working and implementation of Crystal Reports 8.0/9.0/10/Xi.
• Expertise in installing, designing, developing, maintaining and tuning of RDBMS like SQL 2008, 2005, 2000.
• Proficient in creating jobs, Workflows, Data flows, Query and other Transforms in SAP Data services.
• Worked in Market Risk area in a Commodities environment.
• Worked on Data Warehouse design, implementation and support (oracle, SQL server, MySQL).
• Good working noledge of data base design and data modeling.
• Experience in writing complex SQL queries, Stored Procedure and MDX queries.
• Experience with Production (24 X 7) and Development Environment.
• Experience with 2008 new concepts like Date Time data type, Transparent Data Encryption, Grouping sets, MERGE operator, Change Data Capture, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Highly proficient in the use of T-SQL for developing complex creating Database, Tables, Indexes, Views, Triggers, Stored Procedure, User Defined Function, relational database models and data integrity, SQL joins and query writing.
• Data modeling using Erwin Data Modeler and MS Visio.
• Experience with 2005 new concepts like data partitioning, online indexing, Data Definition Language (DDL)triggers, Dynamic Management views (DMV), Dynamic Management Functions (DMF), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)and SQL Server Analysis Services (SSAS).
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Excellent experience of SQL Server DTS and SSIS (Integration Service) package design, constructing and deployment.
• Experience in MS SQL Server 2008/2005/2000 , Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2008/2005/2000 .
• Experience in Data Modeling (logical modeling and physical modeling), Entity relationship diagram (ERD) development/normalization and physical database schema design using Erwin.
• Excellent skills in Log Shipping, Transactional, SnapshotReplication, Database Backup, Linked Servers, DTS.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting, DTS and Jobs.

TECHNICAL SKILLS

Operating Systems: Windows 2003 / NT / XP/ME/9.X

Languages: C, C++, C#, T-SQLWeb Technologies HTML,JSP, WML, XML

Databases: MS SQL SERVER 20 / 7.0, My sql, MS Access 2003

Packages: MS Office 2005, MS Visio, ERWIN, MATLAB

Testing: Win Runner, Load Runner

ETL tools: DTS, SSIS, SSAS, SSRS

Database Tools: SQL Enterprise Manager, SQL Profiler, SQL Query Analyzer, Index Analyzer, SQL Agents, Data Stage, SQL Alerts, Data warehouse lifecycle, SQL Mail, SQL Client Configuration utility, Backup Server, data stage technology concepts.Replication server, OLAP Services, Replication Tool

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

SQL Server DB Dev

Responsibilities:

• Migrating Facets tables data from old schema to new schema on TMG local server for various clients like Affinity, BCBS etc.
• Migrating staging data from TMG server to HMS API using JSON and java queues (using java code in eclipse).
• Created procedures to keep track of all data which is uploaded to HMS server.
• Worked on failure mechanism to keep logs in case of data migration fails.
• Created functions to insert data for missing publications and articles on replication servers.
• Created functions to fetch transactional data from various distribution servers (i.e. Data present in various MSrepl tables) for particular publication and upload it in flat files on local server.
• CreatedSQLjobsand validating the data in the PROD and PPE.
• Validated data between the PROD UI and the Report source file (CSV).
• Provided XML queries for SE team to migrate the data from source files to the PROD environment.
• Created functions to load data from flat files into Postgres DB with the use of external tables.
• Created functions to merge partial commands from transactional server.
• Created batch files to execute all PSQL and sqlcmd commands in sequence.
• Worked on CDC schema to keep track of all transactions.
• Working on new functions to parse through merged commands for update, insert & delete operations on transactions.
• Developed basic drill through reports using SSRS.
• Review of the Code to verify the accuracy, standards and optimizing the queries and minimizing the page upload times.
• Provide Weekly status report to Client
• Provide Reports on Test execution of the team.
• Create scripts for test cases.
• Review and provide feedback on project deliverables.

Environment: SQL Server Management Studio 2016/2014/2012 (SSMS),SQL Server 2000/2005/2008 Visual Studio-Enterprise Edition 2015, PostgreSQL, SQL profiler, XML, JIRA, Windows Command Prompt, Windows 7

Confidential, NYC, NY

SQL Server Developer/SSIS developer

Responsibilities:

• Gathering user requirements for application to meet end Client specifications.
• Analyze the Business Requirements, Functional Specification, Use Cases and Configuration Spec Documents.
• Extensively worked on feeds as required to deliver data from upstream systems to the Quick (Risk calculation) and Raptor (market Risk reporting) databases.
• Design Test Plan, Test Strategies, Test Scripting and Traceability Matrix.
• Writing & debugging the SQL scripts.
• Prepare Automation Scripts using QA Automation Tool.
• Mentor less Experienced Team Members on needy basis on Best practices.
• Maintaining test script relationship and assigning Requirement id for ease of traceability.
• Make recommendations related to maximizing investment in existing test automation tools, identify report, escalate, monitor, and mitigate project and product risk.
• Data extraction, transformation and load (ETL) processes will use DataStage environments.
• Perform a functional testing of Quickcomm/Vodafone products and perform a test script audit of all documented test scripts to make an assessment related to test coverage.
• Representing the defect to the Defect Management Team, Business and Project & Development Management Team.
• Write Complex SQL queries for Data manipulation, insertion, deletion and updates.
• Review of the Code to verify the accuracy, standards and optimizing the queries and minimizing the page upload times.
• Provide Weekly status report to Client &Provide Reports on Test execution of the team.
• Support issue resolution for emergency fixes.
• Consult with key business users and subject matter experts to gather information about Reporting needs, objectives, functions, features, input and output requirements.
• Reviewing HLD documents created by the Business Analysts and Test Plan, Test Strategies& Traceability matrix for Reporting Solutions.
• Developing automated Testing tools using XML, SQL server automated testing tools using XML, MY sql, SQL Server
• Representing the defect to the Defect Management Team, Business and Project & Development Management Team.
• Perform Quality Assurance/Unit Testing before the developed rules and Database Objects moved to Production system.
• Provide assistance to business users to solve operating problems by recreating steps taken by them to locate the source of problem.
• Develop and execute test cases and test plans for Functional, Performance, Stress, and Regression testing needs.
• Create scripts for test cases. Test front-end user interfaces and make usability recommendations
• Review and provide feedback on project deliverables.
• Perform noledge transfer to end users.
• Ensuring delivery of bug frees code to User system and Support the field issues.

Environment: MS SQL Server 2008/2005, Datastage server, T-SQL, SSIS, SSAS, Oracle 10g, MS Excel, Windows Server 2003, JavaScript, XML, ETL, Crystal Report, SQL task, QA Automation.

Confidential

SQL Server Developer

Responsibilities:

• SQL Server 2008 RDBMS database development including T-SQL programming.
• ETL implementation using SQL Server Integration Services (SSIS).
• Developing reports on SSRS on SQL Server (2008).
• Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server using SSIS.
• Created SSIS packages to load the data from Text File to staging server and then from staging server to Data warehouse.
• Provides guidance and advice on SAP Data Migration methodology.
• Designed and developed ETL solutions using SAP Data Services as well as Cransoft.
• Participated in a fully scalable WPF based client/server brokerage application using c#, WCF, Entity Framework and SQL server.
• Performing export and import of Datastage components, table definitions and routines.
• Worked on development of data stage design concepts, execution, testing and deployment on the client server.
• ETL implementation using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship.
• Created/managed configuration files in order to deploy SSIS packages in different environments.
• Support current production jobs by troubleshooting long running queries and optimize them to improve performance using different optimization techniques, DTA/ITW and Execution Plan.
• Wrote function code for different tasks in the database table.
• Extensive experience in Extracting, Transforming and Loading (ETL tools) using SSIS, DTS Import/Export Data, Bulk Insert, BCP, DTS Packages and SSIS packages.
• Created SSAS packages, OLAP cube, and multi-dimensional modeling on Terabytes Database, and worked in Designing and Building Dimensions and Facts with star schema and snowflake schema using SQL Server Analysis Services (SSAS).
• Worked on Control flow tasks such as Execute SQL task, Send Mail Task, File System Task, Dataflow Task and used different data sources and destination with derived column, lookup transformation within Dataflow Task.
• Support current production jobs by troubleshooting long running queries and optimize them to improve performance using different optimization techniques, DTA/ITW and Execution Plan.
• Debugged and enhanced existing stored procedures for better performance gains.
• Experience in creating SSIS packages using different type’s task, with Error Handling, Log particular event by creating logging and worked on package configuration to run package on different server.
• Automate and Product ionized manual jobs by creating SSIS packages and scheduling it through IBM TIVOLI job scheduler.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Re-architecture new database designs.
• Developed database tables satisfying the 3rd Normal form, and complying with referential integrities.

Environment: MS SQL Server 2008/2005/2000 , my sql, SAP,Database Tuning Advisory, IBM TIVOLI, PVCS, INFORMATICA Power Center 8.6.1, Datastage 8.1, Oracle 10g, .NET, c#,Visio 2003, MS Share Point, MS Excel, Windows Server 2003, UNIX, DB2.