Summary

• 11 Years of IT Experience, which includes expertise in all phases of the software development lifecycle SDLC .
• Background includes experience in the use of SQL Server 2000/2005/2008 R2/2012 T-SQL , Oracle PL/SQL , Business Intelligence Development Studio BIDS , DTS/SSIS, SSAS, SSRS, Informatica Power Center , DataFlux, COBOL, Microsoft office products
• Exposure to various stages of Software Development Life cycle SDLC such as System Data Analysis, Data Modeling, client relationships/negotiations, gathering business requirements, project scheduling, development DEV , test UAT , build/release, and production support PROD environments.
• Strong Experience in data modeling using ER-Studio
• Experience in installation, upgrade and configuration of MS SQL Server 2000,2005 and 2008 R2
• Experience in migrating Databases between MS SQL 2000 and 2005 and MS SQL 2008 R2.
• Strong Experience in data warehousing concepts and writing and implementing T-SQL Queries DDL, DML, DCL, TCL , developing reports using SQL Reporting Services, Crystal Reports Business Objects, version control using MS Visual Source Safe VSS , Dimensions ,Clear Case and Team Foundation Server TFS .
• Experience with Structured Query Language SQL , MDX and relational databases.
• Expertise in quantitative and functional data analysis
• Extensive experience in Extracting, Transforming and Loading ETL using Informatica, SSIS, DTS Import/Export
• Used Data Analysis tools like Excel Spreadsheet, SQL objects, Business Intelligence Development Studio, DataFlux
• Strong knowledge and experience in SSAS cubes
• Expert Knowledge in Creation of workflows, mappings in Informatica
• Expert knowledge in Using Microsoft Integration Services SSIS Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks
• Expertise in Monitoring and Troubleshooting and resolving the SQL Server Performance issues.
• Experience in creating Users, Logins, Server Roles and assigning Permissions to connect to Database Engine.
• Have good understanding of complex data sets and skilled at data analysis, data Validation, data cleansing etc.
• Experience in design, deployment and management of SSRS reports
• Experience in writing test cases, performing system and unit testing besides trouble shooting.
• Performing Bug tracking, resolving issues, clearing defects and making enhancements as per any changes in the user requirements.
• Good knowledge on the Software design patterns
• Possess good communication, presentation and team playing skills.
• Have excellent domain knowledge in telecom, banking domain, SPED Special Education process and mortgage industry.

Technical Skill set

Databases: SQL SERVER 2000/2005/2008 R2/2012, Oracle , DB2, MS-Access

Development/Analysis Tools: Visual Studio, SSAS, SSRS, SSIS/DTS, Informatica, DataFlux, ER-Studio,

InfoPath, Quick base, Microsoft Office, Visio, Toad, Iron Speed Designer

.NET Framework: ASP.NET, C , VB.NET, ADO.NET, AJAX, Web Services, LINQ

Web Technologies: IIS, XML, XSD, XSLT, Tomcat

Programming Languages: C, C , Visual Basic 6.0, JAVA

Scripting/Markup languages: JavaScript, VB Script, jQuery, JSP, HTML, DHTML

Source Control: Visual Source Safe VSS , CVS, Dimensions, Clear Case

Operating Systems: MS Windows 2003/XP/NT/2000/9x, MS DOS, UNIX

Project Experience

Confidential

Sr. ETL Developer

Responsibilities:

• Data Sourcing, Data Mapping, Transforming and Importing the data is done through the ETL Informatica packages
• Created Source to Target Mapping sheet
• Worked with Data architect in the design of Dimensional database schemas and created conceptual, physical and logical data model using ER studio
• Managed metadata through data dictionaries
• Involved in Analyzing, compiling, verifying, extracting, converting, validating data for any data inconsistencies and errors
• Created complex PL/SQL Database views, Stored Procedures and Functions
• Redesigned and implemented a dimensional data model
• Developed scrambling functions to mask PPI data
• Created autosys JIL scripts and batch scripts
• Developed ETL scripts to find files matching a pattern in an inbound folder and created audit log and error handling at task level
• Created Functional and technical design documents together with design document and unit test plans and test scripts

Technologies: Oracle 11g, Informatica Power Center, Toad, Teradata, Visual Studio 2008, Visual Studio 2005, Autosys, Beyond Compare, Rational ClearCase, ClearQuest, Unix, Windows, Microsoft Visio

Confidential

Senior ETL Developer

Responsibilities:

• Developed Informatica packages to load the FAA data into Survey DB
• Created and managed schema objects such as tables, views, cursors, indexes, stored procedures, triggers and functions
• Optimized the PL/SQL code for performance, Improved the performance of the table joins by implementing index scans where ever required
• Analyzed the data to ensure validity, accuracy and quality
• Worked extensively on installation and configuration of MS SQL Server 2008 R2 databases/ servers.
• Administered the database server by creating user logins with appropriate roles, monitoring the user accounts, granting the privileges to users.
• Developed the survey forms in InfoPath 2007
• Migrated the survey forms from InfoPath 2007 to InfoPath 2010

Technologies: Oracle, Informatica Power Center, Visual Studio 2008, Business Intelligence development Studio, Infopath 2007, jQuery , Windows

Confidential

Senior ETL Developer

Responsibilities:

• Extensively involved in fine tuning stored procedures and other database objects to improve performance
• Involved in creation of ETL Informatica packages and automated to run as scheduled jobs and troubleshooting any failed jobs
• Created Source Analyzer, Target, Mapping, Session, Workflow in Informatica
• Enabling tracing and collecting trace data to identify the slow running stored procedures and queries
• Ran the jobs that loads data from the external systems on demand
• Created and maintained materialized views
• Created additional forecast reports in Panorama

Technologies: Oracle, Informatica Power Center, Toad, Business Intelligence Development Studio, Visual Studio 2005, Iron Speed Designer, Windows

Confidential

ETL Developer/Data Analyst

Responsibilities:

• Involved in Requirement Analysis, logging Issues and gathering Business Requirements and developed Functional Design and Technical Design documents
• Involved in Data mapping, logical data modeling and preparing ERD diagrams
• Created and managed SQL objects such as tables, views, cursors, indexes, stored procedures, triggers and functions
• Wrote complex T-SQL PL/SQL Statements to ensure data consistency by filtering corrupt data and implemented various constraints and triggers to preserve data integrity
• Migrating the Student Data Special Ed from old system SQL Server 2000 Excel Spreadsheets to new system SQL Server 2005
• Developed DTS packages for the creation of daily feed student demographic data and upload to the new system
• Designing, Developing and Deploying various ETL packages SSIS Informatica
• Migrated SQL Server 2000 DTS packages into SSIS SQL Server 2005
• Created, Deployed and Managed Reports through SQL Server Reporting Services SSRS
• Involved in Creation and maintenance of Business objects reports
• Generated Data Cleansing reports using Crystal Reports in Visual Studio
• Developed a quick base application

Technologies: Informatica Power Center, SQL Server 2005, SQL Query Analyzer, Business Objects, Serena Dimensions, Visual Studio 2005, C .NET, Windows

Confidential

Analyst/Programmer

Responsibilities:

• Prepared the Requirement gathering and Analysis, Detailed Design and Test plan
• Wrote COBOL stored procedures
• Involved in the optimization of the queries used in the stored procedures
• Developed PL/SQL Procedures and functions
• Used various tools like Toad, Beyond Compare and XML Spy for ease of development and analysis
• Developed Use case, sequence and class diagrams
• Created web pages using ASP.Net, CSS.
• Involved in Business and Data layer development using VB.Net and ADO.Net
• Involved in developing client side scripting files using JavaScript for dynamic actions as well as validations to be performed at client-side

Technologies: SQL Server 2000, Oracle, SQL Query Analyzer, Java, VB, Visual Source Safe, Windows

Visual Studio 2002, ASP.NET, VB.NET, Cobol, Visual Source Safe, Windows, C , Toad, Beyond Compare, XML Spy