SUMMARY

• Around 3+ years of professional experience as SQL Developer in development, implementation and administration of database systems using Confidential DB2 and MS - SQL Server 2012/2008/2005/2000 for both OLTP & Data Warehousing applications.
• Experienced Business Analyst in business requirements gathering, business process analysis/modeling, Design, Reviews, Coding and Code reviews, Unit and Integration Testing.
• Experience in ETL Design, Entity-Relationship Modeling and Dimensional Modeling.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio.
• Successful in identifying the needs of a business or business process and quantifying those needs into technical requirements employing Unified Modeling Language (UML) or Entity Relationship Diagram, data flow diagrams using tools like MS Visio.
• Strong understanding of Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Expert in process flow and data flow diagramming, use case analysis and user stories.
• Expert in using Excel (Pivot tables, Macros, Lookups, Graphs, Charts, Formulas & Functions), Access for Data analysis, data visualization, Tableau, database development, report development.
• Good Knowledge on big data technologies like Hadoop, Hive and Python and proficiency in statistical analysis tools like Tableau.
• Lean Six Sigma Green belt certified Business Analyst with strong analytical skills to understand business needs, ability to identify new business opportunities, and optimize existing and propose new business processes to achieve organizational goals in today's competitive business environment.
• Industrial experience coupled with communication skills which would help in effective productivity.

TECHNICAL SKILLS

Programming skills: T-SQL, PL/SQL, Confidential DB2, Shell Script, Hadoop, Python, Hive, GIT/GITHUB, C, C++, Java Script, VB.NET, C#, ASP.NET, MVC, Java.

Technologies & Tools: SSIS, SSRS, Black Board, SharePoint, Oracle 8i/9i/10g, JIRA, HP QC/HP ALM, PeopleSoft, MS-SQL 2012/2008, MySQL, Tableau.

Web Development: HTML 5, CSS, XML.

SAP Skills: FI, CO, SD, MM and PP/ME Module, ABAP Programming

Other Skills: Microsoft Office, Microsoft Visio, Visual Studio, Lean Six Sigma

Operating Systems: LINUX, Windows, OSX

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, Baltimore, MD

Responsibilities:

• Worked on Confidential Unified Case Management Project.
• Developed complex Stored Procedures, Packages, Triggers, Cursors and Shell Scripting in Confidential Data Studio.
• Identified the sources, targets and developed ETL mappings.
• Developed sessions, workflows which involve command tasks to invoke the ETL.
• Responsible for creating and maintaining the stored procedures and Performed Unit Testing the mappings and workflows and created Unit Test Results and conducted self review and peer review of the code and test results.
• Extensively used ETL to load data from wide range of source such as flat files, Mainframes to DB2.
• Involved in migrating folders from Development to Testing and from Testing to Production.
• Performed Database/ETL migrations from Dev environment to Test/Training/ UAT/Staging and PROD environments.
• Backend database Testing in DB2 Data studio environment including validating stored procedures, jobs and triggers, utilizing queuing systems, reviewing logs.
• Design and develop SSIS ETL packages per the requirement to enhance existing system from heterogenous data sources like SQL, DB2 via direct query.
• Involved in identifying facts and dimensions for the Data Mart based on reporting requirements and existing reports.
• Worked with Data Modeler in designing and Updating the Star Schema using Erwin.

Graduate Teaching Assistant

Confidential

Responsibilities:

• Supported faculty in their research projects.
• Mentored students in class on using tools like Excel, Access, Visio.
• Extensively used SQL and data cleansing and analysis using pivot tables, formulas (v-lookups and others), data validation, conditional formatting and graph and chart manipulation.
• Helped students in designing their own projects for business and business models.
• Assisted course instructor with teaching, grading and managing course material website.

Instructional Technology Assistant

Confidential

Responsibilities:

• Assisted faculty in Blackboard and SharePoint. Support elementary instructional personnel with the presentation of technology-based instruction and exercises in the classroom or computer laboratory; install and maintain hardware and software campus-wide.
• Assist in standardization, documentation, and implementation of overall physical data management and data release processes.
• Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language. Data analysis on climatic data using cross validation techniques.
• Developed various T-SQL stored procedures, functions, views and adding/changing tables for data extraction, data load and transformations.
• Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.
• Worked with Stored Procedures to handle various checks, to generate the ballot and the voting demographics were written in SQL Server 2008.
• Responsible for creating the reports based on the requirements using SSRS 2012.
• Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.
• Utilize PL/SQL, Hadoop and occasionally R to conduct statistical analysis on a variety of institutional and academic related data.
• Generate various internal reports and data requests regarding graduate education at university.

SQL Developer

Confidential

Responsibilities:

• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL, Queries, SQL Query tuning process and Schemas.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Wrote SQL Stored Procedures, Functions, and Packages to meet the business requirements.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and TOAD.
• Addressed Data Quality Issues using SSIS package and Load the Data into Exception table.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
• Performed data profiling, data analysis to identify legacy data that needs to cleanse prior to the migrations using SSIS Data Profiling Task, Data Profile Viewer and T-SQL Queries.
• Converted DTS Package to SSIS package for synchronizes existing process (DTS migrations).
• Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data into the Data Warehouse.
• Designed SSIS Packages using various Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, Execute Package Task, active script task, xml task.
• Performed performance tuning. Analyzed existing Excel workbooks and replaced VLOOKUP’s functions.
• Analyzed data and reported solutions to understand quality of data, correlations/discrepancies and proposed changes alternative solutions.
• Provided analytical support and documentation for databases after collaborating with IT to prepare current systems for migration to new business intelligence system.