SUMMARY

• About 7 years of IT experience in Data Analysis, System Application Analysis, Data Architecture, analysis and Development, Testing and Deployment of Business Intelligence using Data Warehousing and Database Business Systems in the areas of health, insurance, finance Industries.
• Experience in MS SQL Server 2012/2008 with Business Intelligence in SQL Server Reporting Service and SQL Server Integration Service.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL, Oracle10g, OMWB tool.
• Experience in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Developed queries and macros for reporting purposes.
• Automated the printing process of excel reports such as performance matrix report and Budget spending report on monthly and YTD(Year to Day) basis and sending them as an email attachments using Excel/VBA macro.
• Strong MySQL and SQL Server skills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Involved in migration of SSRS reports from SQL 2000 to SQL 2012/2008 and migration with DTS to SSIS2012/2008
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using different Utilities.
• Created reports for the users using Tableau by connecting to multiple data sources like Flat Files, MS Excel, CSV files, SQL Server, and Oracle.
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation
• Worked extensively on excel macros and SQL * loader for loading data and also worked on VBA (Visual basic for application).
• Experience in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2012/2008
• Experience in dimensional data modelling and Cube development, partition, aggregation and optimization using SSAS
• Building and writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2008/2012Analysis Services Business Intelligence (SSAS, SSRS).
• Experience in advanced reporting skills using SQL Server reporting services (SSRS).
• Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes
• Extensive experience in developing tools using Access, VBA, Excel environment.
• Experience in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, effective functions, and appropriate

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Analysis Service (SSAS), VBA (Visual basic for application)ETL Tools Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services (2012/2008), Tableau

Database: MS SQL Server 2012/2008/2005, MS Access, Oracle 11g/10g/9i/8i, MS EXCEL macros

Programming: T-SQL, PL-SQL, C, LINUX (Shell Scripting) Web Technologies HTML, DHTML

Operating Systems: Windows, Unix, Linux, Mac OS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Adobe Photoshop, Abode Flash, Mac Office Suite, Rational Rose, MS excel macros

PROFESSIONAL EXPERIENCE

Data Analyst

Confidential - Salt Lake City, UT

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Worked on fixed income derivative portfolio solution with various portfolio performance and risk measures using Excel, Access, SQL Server; Greeks, Black Scholes.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, Execute package task
• Created packages in SSIS with error handling
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Queried the databases, wrote test validation scripts and performed the System testing.
• Worked with the developers during coding and while doing the remediation of the software.
• Worked with the users to do the User Acceptance Testing (UAT).
• Involved in data warehouse design.
• Experience with various ETL, data warehousing tools and concepts.
• Worked with different methods of logging in SSIS.
• Wrote macros to convert Excel data into to a web page
• Developed Word forms using VBA to conduct various surveys in order to optimize monthly report based on team usage.
• Wrote various Excel VBA scripts and access queries to massage raw data from carriers across the globe to standardize the data input format and used pivot tables/charts extensively for presenting various trend analysis to the department.
• Experience in creating complex SSIS packages using proper control and data flow elements
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Supported team members in pricing module development of fixed income products using Excel and VBA.
• Developed Excel/VBA based financial programs utilizing Bloomberg API to monitor market volatility, key rate duration and Monte Carlo simulations to estimate VAR with particular focus on relative value trading as well as mapping of yield curve reshaping/shifting scenarios.
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model
• Querying and manipulating multidimensional cube data through MDX Scripting
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Developed stored procedures and triggers to facilitate consistent data entry into the database
• Wrote stored procedures to generate account statements for different types of accounts
• Upgrade enhancements, maintenance, production support and bug fixes for the project

Environment: Microsoft SQL Server, SQL Server Integration Services tools (Macros, SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle, MS Excel, Macros.

Data ware house analyst

Confidential - Miami, FL

Responsibilities:

• Involved in analysis of end user requirements and business rules based on given documentation and worked closely with tech leads and Business analysts in understanding the current system
• Assisted Business Analyst in documenting business requirements, technical specifications and implementation of various ETL standards in the mappings
• Configured Power BI dashboards and reports.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams
• Analysed the business requirements and involved in writing Test Plans and Test Cases.
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables.
• Developed views, functions, procedures, and packages using PL/SQL & SQL to transform data between source staging area to target staging area.
• Wrote SQL queries to perform Data Validation and Data Integrity testing.

Data analyst

Confidential - Chattanooga, TN

Responsibilities:

• Worked closely with Project Team, SME and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications.
• Involved from beginning of the project such as of Statement of Work (SOW) to post implementation of SDLC process.
• Assisted Project Manager in scope estimation and work breakdown structure (WBS) to meet Project Milestone.
• Analyzed Autosys job flows and created JIL's for data validation process such as pre and post load SQL checks.
• Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables.
• Defined frameworks for Operational data system (ODS), Brokerage data warehouse (BDW), Central file distribution (CFD) and Data Quality (DQ) and created functional data requirement (FDR) and Master Test Strategy documents.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements .
• Performed impact analysis for DB2 tables that needs to be compressed and archived to implement the lower cost storage mechanism.
• Defined target load order plan and constraint based loading for loading data correctly into different target tables.
• Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing(SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Coordinated with offshore vendor and established offshore teams and processes for code development.
• Coordinated with execution team to define the batch flow for data validation process.
• Involved in all execution phases such as Pre-Mock, Mock1, Mock2, and Mock3 before implementing the conversion data into live event.
• Involved in the Red 4front data quality issue for further analysis and resolving root cause issue for data failure.

Environment: MS Project, Microsoft Visio, C#, Rational Suite (Requisite Pro, ClearQuest, ClearCase), Requisite Pro, ClearCase, Rational Rose, Business Objects ClearQuest, DOORS, Informatica, Visual Studio 2008, Biz talk Server 2009, Visual C#, MS SharePoint Services

Data ware house analyst

Confidential - Knoxville, TN

Responsibilities:

• Worked in Various stages of Data warehousing life cycle of development database logical and physical design, ETL process, performance tuning on Windows NT, UNIX operating systems.
• Created Mapping Documents, ETL technical specifications and various documents related to data migration.
• Provided support to Data Architect and Data Modeler in designing and implementing Databases for MDM using ERWIN Data Modeler Tool and MS Access
• Involved in the Database Designing (Relational and Dimensional models) using Erwin.
• Performed data analysis and data profiling using complex SQL on various source systems including Oracle and Netezza.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Managed, updated and manipulated report orientation and structures with the use of Pivot Tables and V-Lookups.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail & Pivot reports.
• Implemented very advanced and complex queries in DDL and DML involving Joins, Sub queries. Alter Table etc.
• Active involvement in Optimization Process through database capacity planning, creation of materialized views, partitions, tables, views, indexes as tuned and optimized SQL statements.
• Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
• Created T-SQL stored procedures to improve the performance of aggregate queries dynamically.
• Designed and Developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data
• Coordinated with the offshore team in the testing process of the SDA (Signal Detection and Alerts) & CBS( Corporate Business Support) Cognos custom reports.
• Created RTF files for summarizing results and creating, modifying, importing and exporting Metadata using SAS ODS.
• Developed SAS code, VBA code to automate report generating process.
• Assisted in logical and physical Modelling for OLAP and OLTP systems.
• Extensively worked on the ETL mapping, source data analysis, source to target mapping and documentation of OLAP reports requirements.
• Used TOAD Software for querying Oracle.
• Developing batch files to automate or schedule tasks.
• Experience in Data Visualization including producing tables, graphs, listings using various procedures and tools like Tableau.
• Worked with Tableau Report Writers to test, validate data integrity of reports.
• Support for the development, pre-production, and the production databases.

Environment: ETL, Erwin, UNIX, T-Sql, Tableau, Cognos, Metadata, SAS, Netezza, MS Access, Oracle, SQL Server 2008, TOAD, Windows NT

SQL server Developer

Confidential

Responsibilities:

• Worked with project lead and business users to understand business processes
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
• Worked with T-SQL to create Tables, View and stored Procedures
• Created triggers on DML actions for security purpose
• Worked with Scalar and Table Value User Defined Function as per business requirement
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions toinsert the data depending on the criteria into the tables
• Encapsulated frequently used SQL Statements into stored procedures and reduced the execution time Wrote Merge Statement to handle insert, update and delete within single statement between source and destination table
• Interacted with financial analysts to gather requirements, test plans and DBA's for database schemas.
• Designed and developed MS Access user interfaces with user validations using VBA.
• Used VBA extensively and provided options to query the data based on their selection.
• Imported data from SQL Server into Access.
• Created Excel applications (VBA, Macros) to import historical data which include multiple databases and perform various statistical analyses, charts and graphs.
• Developed user defined functions to calculate performance attributions, Sharpe ratio and various other functions to evaluate investment manager's performance
• Developed multiple Excel/VBA Forms for data capture and report generation Used PL/SQL collections (Nested Tables and Varray) in complex backend packages.
• Coded UNIX shell scripts to call SQL scripts and to manipulate the returned data.
• Developed test plan documents for all back end database modules.
• Extensively worked on Explain Plans and various hints for Performance tuning.
• Wrote Database triggers for audit and to implement complex business logic.
• Discussed and analyzed business functionality with the client and the developers.
• Involved in the database design for better understanding the relations, associations and dependencies within the data base.
• Created bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Involved in writing functional and technical documents.
• Generated SQL scripts for crating tables, Views, Primary keys, Indexes, Constraints, Sequences and Synonyms.
• Promoted RDLs to Reporting Service Server
• Developed various Excel and Word templates using VBA, Macros for various Reports and Client communication letters; packages the application using Access Forms and VBA.
• Developed various Excel and Word templates using VBA, Macros for various Reports and Client communication letters; packages the application using Access Forms and VBA. Used Visual Source Safe (VSS) for version control.

Environment: Microsoft SQL Server, SQL Server Integration Services tools (Macros, SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle, MS Excel, Macros.