SUMMARY

• A Microsoft Certified Professional with over 10+ years of IT experience in the field of software development, Business/Data analysis, ETL Development, Data Modeling, Data Analysis, Data Profiling, Data Migration, Data Integration and identifying data mismatch.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Extensive experience in creating Stored Procedures, Packages, Functions, Triggers, Materialized Views, Cursors, SQL Tuning/Performance tuning of SQL queries and other database objects using SQL, PL/SQL.
• Experience in leading small sized teams (3 - 11) and managing clients.
• Extensive knowledge of Client/Server and Web based applications using Visual Basic 6.0, ASP.NET (1.1/2.0/3.5.4.5 ), ADO.NET, C#, VB.NET, Web Services, and Entity Framework.
• Experience in Technical Areas like Analysis, designing, programming, configuration control, code reviews, test planning, estimation, UML, user training.
• Extensively worked in developingETLfor supporting Data Extraction, transformations and loading usingInformatica Power Center
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Demonstrated proficiency in requirements gathering (interview techniques, JAD sessions, questionnaires), requirements analysis (documentation: sequence, activity, state, or UML diagrams; prioritization, cost/benefit,), business process re-engineering and project management.

TECHNICAL SKILLS

NET Technologies: ASP.NET, Windows Forms, MVC, Programming Language: C#, VB.NET

Scripting languages: JavaScript, ASP, VBScript, jQuery

.Net Framework: Framework 1.1, Framework 2.0, Framework 3.5, Framework 4 and Framework 4.5

Other Technologies: WPF, WCF, XML, XSLT, JSON, AJAX, UML, HTML

Databases Servers: SQL Server 2000, 2005, 2008,2012 MySQL5.0, Oracle 10g, Oracle 11g

Version management: VSS, CSV, SVN.

Reporting: SSRS, Hyperion BRIO and SAS BI.

Analytics/Profiling: SAS 9, BRIO and, DataFlux.

ETL: SSIS and Informatica

PROFESSIONAL EXPERIENCE

Confidential, Westwood, CA

Senior software Engineer

Responsibilities:

• Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs
• Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations.
• Created SSIS package to move historical data in legacy system to the new Sql-Server 2008 database.
• Performed Data Cleansing and Data Profiling using several transformations like Data Conversion and Derived Column.
• Gathered business requirements, working closely with business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.
• Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.
• Develop detailed technical specifications and ETL documentation in collaboration with data warehouse architect and Business Intelligence developers
• Effectively articulated reasoning for data model design decisions and strategically incorporated team member feedback to produce the highest quality data models.
• Created SSIS Reusable Packages to extract data from Multi-formatted Flat files, Excel, XML files, Db2 into SQL Server database.
• Performed the Unit and functional testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables)
• Creating standard set of data definition artifacts, including all data elements imported and exported across all data files (front-end and back-end).
• Created reports using MVC C# technology.

Confidential, Torrance, CA

Senior Data Analyst

Responsibilities:

• Wrote Stored Procedures for performing optimization and other database operations such as complex SQL queries, views and triggers etc.
• Implemented Multi-Layer ETL Data Extracts, Data Load Logic, Mapping, Work Flows, stored procedure.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Created SSIS package using Fuzzy logic feature to do data profiling and data cleansing.
• Worked with internal architects and, assist in the development of current and target state enterprise data architectures
• Created and maintained SharePoint website 2013 for centralized team information sharing.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Generated dashboard reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Extensive hands on experience in ETL domain. Have Designed, Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings usingPower Center -Designerto extract the data from source systems to target system
• Performed SQL validation to verify the data extracts and record counts in the database table
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Performs analysis of business models, logical specifications and/or customer requirements to design and build business solutions utilizing multiple technologies.
• Works with stakeholders following the Agile Scrum software development process.
• Troubleshoot and optimize ETL code; interpret ETL logs, perform data validation, dissect code, understand the benefits and drawbacks of parallelism, apply best practices using change data capture, expressions, scoping of variables, commonly used transforms, event handlers and logging providers, understand and optimize the surrogate key generation and inconsistent data type handling.
• Designed and implemented Entity Framework to connect and retrieve or manipulate database information
• Partnered with stakeholders to identify business problems and develop state-of-the-art solutions aligned with business objectives. Provided data warehouse & BI technology vision, roadmaps and blue prints and project plans.
• Worked on Microsoft Team Foundation Server for version control, individual task status and Database server project.

Confidential, Irvine, CA

Senior Data Analyst/ Programmer Analyst

Responsibilities:

• Understand multiple data sources across the company, and help collecting and documenting data lineage and data dictionary into a metadata management tool.
• Participated in the discovery sessions by conducting interviews/walkthroughs of cross-section of stakeholders to understand the current state of data quality and expectations from a data governance structure.
• Use DataFlux to facilitate the automation of certain data mapping tasks.
• Create XML mapper file using SAS XML mapper 9.4
• Created process flow diagrams by using MS Visio to understand key processes and document the potential for data quality redundancy. Parse XML files using DataFlux and generate reports and upload it to Metacenter which is a Data Advantage Group tool.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Designed SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Identify causes of poor data quality, implement solutions and communicate findings to employees, management, and stakeholders.
• Create jobs/processes in DataFlux to automate reporting which helped stakeholders to make business decisions.
• Conducted detailed GAP analysis by creating use case document, data quality issue document and metadata strategy document.
• Identified and worked with Parameters for parameterized reports in SSRS 2005.
• Worked pro-actively with Data Stewards and Subject Matter Experts and other specialist to help resolve data conflicts and data quality issues
• Compile and track data quality metrics via scorecards and dashboards
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks

Confidential, Herndon, VA

Senior Data Analyst / Data Architect

Responsibilities:

• Write advanced SQL queries in SQL server 2008 to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Worked with data mapping from source to target and data profiling to maintain the consistency of the data.
• Involved in Software development life cycle (SDLC) of application from design phase to implementation phase, testing, Deployment and maintenance phase
• Translated Business Requirements into working Logical and Physical Data Models.
• Identified, formulated and documented detailed business rules and Use Cases based on requirements analysis
• Participated in daily Scrums with the whole team to discuss about the progress of the application development, specks to be taken care and specks that already completed
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard
• To maintain the consistency and quality of the data worked with Data governance, Data Profiling and Data quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.
• Designed Graphical User Interface (GUI) using Layout Pages, HTML JQuery, CSS classes and Custom Controls

Confidential, Bloomsburg, PA

Senior Data Analyst/ Programmer Analyst

Responsibilities:

• Created Stored Procedures for Interaction with database using T-SQL in SQL Server 2008.
• The project went through full SDLC using Agile. Used UML for designing the application. Used Design Patterns.
• Coordinate with the QA Team for Unit Testing and Integration Testing of different modules
• Created SSIS package to upload monthly files in SQL-server
• Data analysis, definition across systems, and understanding all data flowing through the systems supporting administrations and customer deliverables.
• Serve as an end-to-end expert with stage ETL from operational source systems (e.g. txt files), and secondary ETL/data mart jobs; core ETL script dev/QA, data-mart SPs/agent jobs dev/deployment.
• Worked on Requirements Traceability Matrix to trace the business requirements back to Logical Model.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed aConceptual modelusing Erwin based on requirements analysis

Confidential, Seattle

Senior Data Analyst / Programmer Analyst

Responsibilities:

• Provided maintenance and support maintenance of database schema, tables, procedures and users/user access levels for each segment of database and modify existing databases and database management systems for website
• Facilitated the quality management activities by performing code reviews and coordinating quarterly audits for the project
• Extracted data by running SQL queries, and analyzed financial and customer metadata that gets populated on the web application
• Created mapping document to load the existing data from MS Access database to the newly designed relational database.
• Gathering and translating business requirements into technical designs and development of the physical aspects of a specified design.
• Performed Debugging on the Stored procedures for the requirement to handle the errors

Confidential

Programmer Analyst / SSIS developer

Responsibilities:

• Developed the front end using ASP.Net and middleware components using C#
• Responsible for gathering requirements, performing gap analysis, development, and final support tasks
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Design and develop rich user interfaces with HTML/CSS/JavaScript
• Created Tables, Stored Procedures, Views, Index's and involved in designing of Database tables.
• Performed Data cleansing and Data profiling for detecting and correcting inaccurate data from the databases and to track data quality and to assess the risk involved in integrating data for new applications
• Used Microsoft Team Foundation Server (TFS) for integration, maintenance and Security of code
• To maintain the consistency and quality of the data worked with Data governance, Data Profiling and Data quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.

Confidential, Houston, TX

Responsibilities:

• Designed and developed a C# web service that take reliability data from local database using WCF services and store them in a centralized database.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Designed and developed Reliability tool that runs on any windows system and gathers tool run data.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Optimized the C# code to decrease the execution time from 5 minutes to 30 seconds.
• Constructed a dynamic XML based applications for quicker updates and decreased software maintenance expenditure.

Assistant System Engineer/ Sr. Software Developer

Confidential

Responsibilities:

• Developed master pages, Ajax Controls, web forms in ASP.NET using C# as the code-behind language. Used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data List for reading/updating records in the database.
• Created Scope of Work (SOW) document for Housing and development authority (HOD), Botswana.
• User training Responsible for conducting user training and user acceptance testing to ensure and verify system is designed according to user needs.
• Analyzed long running slow queries using SQL profile and tune the same to optimize application and system performance.
• Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used

Confidential

Software Engineer

Responsibilities:

• Designed and developed Web pages and web services using ASP. Net and C#.Net
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.