SUMMARY

• A self - motivated individual with over 10 years of experience as an Business Intelligence and Data Integration Architect in Information Technology with focus on Microsoft SQL Server, BI Suite, Oracle database for web based and Client- Server applications, effective use of Relation Database methodologies, and strong technical understanding.
• Experienced working on projects with full life cycle development (SDLC) including Agile (Scrum/XP), Rational and Waterfall.
• Excellent knowledge of Relational Databases, Data Warehouse and ETL Processes. Excellent analytical, diagnosis, probing and problem solving skills. Strong interpersonal and organizational skills and able to learn and implement new technical skills quickly without much supervision.
• Expertise on Microsoft SQL Server and BI Suite
• In depth proficient experience in OLTP, Operation Data Sources (ODS), and Dimension Modeling, Performance Tuning, Data warehouse, OLAP and Database technologies
• Experience in Data Modeling using ERWIN, ER-STUDIO, IDA
• Experience doing data modeling and analysis for RDBMS such as SQL Server, Oracle.
• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS
• Extensive experience in T-SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server
• Thorough understanding of EA frameworks such as TOGAF 9.1
• Have good expertise in Oracle 11i/ 10g SQL, PL/SQL, ETL Technologies, Cognos Report Net and performance tuning.
• Experienced in Development, Data Modeling, ETL Design, Performance tuning, Implementation, Troubleshooting and error handling.
• Good experience in various Industry verticals like Banking & Finance, Retail, Warehousing and Distribution with appropriate Data Warehouse/ ETL implementations.
• More than 3 years of experience in utilizing ETL tools including SSIS, Informatica, DataStage
• Experienced with Agile - SCRUM, Xtreme Programing, Rational and Waterfall methodology.
• As part of assignments, has been in Analysis, Design, Development, Project Management activities and QA
• Have Data modeling experience in Star Schema/ Snow Flake schema design, Fact and Dimensions tables, Physical and Logical.
• Extensively involved in Reconciliation and Recovery process for capturing the incremental changes in the source systems for updating in the staging area and data warehouse respectively.
• Worked on different projects as a Team Member and Module Lead for different projects.
• Fully conversant with SDLC methodologies, Application Development, Reports Development using COGNOS Report Net and Quality Assurance.
• Have an experience in customization of a database as per client’s requirements.
• Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Interpersonal Skills.
• Experience in working with all levels of Executives, Data Governance, DBA, BA, ETL and Application Developers
• Strong Team building and mentoring skills.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio,DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2005/ 2008/ 2010/ 2012 , Oracle 9i/ 10g/ 11g, MS-Access.

Language: T-SQL, PL/SQL, Java, C, C#, C++, HTML, XML, MYSQL, DHTML, PERL, VB.NET,ASP.NET, .NET Frame Work, COM, COM+, C#, ASP, JavaScript, VBScript and ShellScript

ETL Tools: DTS, SSIS, Informatica, IBM DataStage

Reporting Tools: SSRS, Crystal Reports XI, Business Objects XI r2, Cognos Report Net

Database Tools: Embarcadero, SQL Developer, TOAD, SQL-Navigator, SQL*Plus

Data Modeling Tools: Physical and Logical Data Modeling using ERWIN and MS Visio

Tools: Microsoft SharePoint

Source Control System: Team Foundation Server, PVCS

Operating System: Windows and Unix platforms

.NET Framework: MS VISUAL STUDIO 2008/ 2010/ 2012 , C#.NET, ADO.NET, WCF, WPF

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Domain Knowledge: Banking and Financial services, Warehousing and Distribution

PROFESSIONAL EXPERIENCE

Confidential, Chicago

Business Intelligence and Data Integration Architect

Responsibilities:

• As a database architect played active role during the requirements gathering, analyzing and designing of the ETF Hub, Web Site and Reports
• Migrated data from Heterogeneous Data Sources and legacy system (Oracle, Access, and Excel) to SQL Server databases using SQL Server Integration Services (SSIS)
• As an Architect designed Procedures, Functions and Packages for ETF Hub, Web Site and Reports Modules.
• As a database designer, designed the db schema using Erwin and wrote the script to create the tables, sequences, constraints ETF Hub database.
• Prepared Technical Documentation, this includes Data Model, Data Flow Process and Batch Database Processes.
• Utilized PL/SQL, Shell and Perl scripts for the scheduling, extraction, transformation and loading (ETL).
• Extensively involved in design of ETL framework, data warehouse development, and implementing ETL development best practices.
• Designed for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB sources.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2012
• Analyzing the current systems and providing recommendations to improvise the performance and to implement control data checkpoints.
• Involved in Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Designed and implemented robust dynamic audit platform for Audit reporting.
• Prepared Technical Design Documents.
• Have in depth knowledge in understanding the sources and target systems which are used for conversion.
• Responsible for customization of business maps, implementation of business rules.
• Involved in the technical review of the deliverables, status calls and review meetings.

Environment: MS SQL Server 2008/ 2012, SQL Server Integration Services (SSIS), SSAS, SSRS, T-SQL, OLAP Services, Oracle 10g/11g, .Net, XML, Windows 7, UNIX, Shell Scripts, Perl Scripts, TFS, and SharePoint.

Confidential, Chicago

Business Intelligence and Data Integration Architect

Responsibilities:

• As database developer, developed Procedures, Functions and Packages for DataSuite.
• As a Data Architect, designed the db schema using Erwin and script to create the tables, sequences, constraints for Benchmark Modeling database.
• Defined S2T Mapping along with Transformation and implemented multiple ODI Mappings, Packages, Procedure to load data from and to (Oracle & MS SQL Server), Delimited Flat Files, Fixed Length, Multiline Record flat files, XML Files to integrate DataSuite data feeds.
• Designed Staging Database using ER-win and SSAS Wizard.
• Prepared Technical Documentation, this includes Data Model, Data Flow Process and Batch Database Processes.
• Worked on invoking WSDL and Restful web services to access remote procedures and landed XML files to have them in SQL Server database.
• Designed Operational Data Store, DW & Data mart flexible data models. Logical & physical models creation. Metadata, partitioning & indexing strategies. Data profiling & data gaps.
• Utilized Oracle Warehouse Builder (OWB), Toad, PL/SQL, crontab, bash and Perl scripts for the scheduling, extraction, transformation and loading (ETL) of benchmark data.
• Developed Extraction, Transformation and Loading SQL scripts Packages, stored procedures and Functions totransfer the data from the source system into the Data warehouse database using SQL*Loader as well as Oracle Import/Export option.
• Involved in Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Optimized the session parameters as well as intelligent index creation and dropping scripts along with updatestatistics to have an efficient data load process.
• Extensively used stored procedures, functions and triggers.
• Worked with DataStage Designer, DataStage Manager and DataStage Director and integrity for creating and implementing jobs.
• Worked with DatsStage Manager for Export & Import Jobs and Meta Data from Repository.
• Prepared Technical Design Documents.
• Have in depth knowledge in understanding the sources and target systems which are used for conversion.
• Have specialized in data migration tool Contextia.
• Responsible for customization of business maps, implementation of business rules.
• Responsible for development of migration projects using the Contextia tool and also fixing the issues.
• Involved in the technical review of the deliverables, status calls and review meetings.

Environment: MS SQL Server 2008, SQL Server Integration Services (SSIS), SSAS, SSRS, T-SQL, OLAP Services, Oracle 10g/11g, .Net, XML, Windows 7, UNIX, Shell Scripts, Perl Scripts, TFS, and SharePoint.

Confidential, Chicago

Sr. MS SQL, Oracle and Data Warehouse Developer

Responsibilities:

• Involved in creating complex Stored Procedures, Views, Triggers and Functions.
• Performed backup of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Performance tuning to optimize SQL queries using query analyzer.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Migrated from SQL Server 2005 to SQL Server 2008 and worked on the transition.
• Created Cross-Tab, Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Wrote the queries for the drill down reports.
• Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to User on demand Basis or run on daily, weekly and monthly basis in SSRS report Manager
• Formatted the reports using the Global variables and expressions.
• Performed data migration using tools like DTS, BULK INSERT and BCP between different homogeneous/heterogeneous systems and SQL Server.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Implemented Event Handlers, Error Handling and Logging in SSIS packages and notified process results to various user communities.
• Packages, and Fuzzy Look-up for data cleansing, validating data using SSIS.
• Used C# and vb.net in script task and ActiveX script task.
• Extracted large volumes of data from various data sources and loaded the data into target data sources by performing different kinds of transformations using (SSIS).
• Integrating Score Cards and Dash Boards with Share Point (MOSS 2007).
• Used ProClarity to Browse Cubes and create some Views and Books.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005 Analysis Services.
• Developed several MDX calculations to get the weighted averages for metrics such as Weighted Average Gross Margin, Weighted Average Term.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models using ERWIN.
• Developing the User-Interface Front-end screens in .Net 3.5 environment using C#.Net, Asp.Net, JavaScript, HTML and DHTML
• Implemented SQL queries in the C# code and VB.Net.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Administering SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Prepared Technical Documentation, this includes Data Model, Data Flow Process and Batch Database Processes.
• Extensively used stored procedures, functions and triggers.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SSAS, SSRS, T-SQL, OLAP Services, Oracle 9i/10g, Embarcadero, TOAD, Informatica, Java, .Net, XML, Windows 7, UNIX, Shell Scripts, Perl Scripts, TFS, and SharePoint.

Confidential, Chicago

MS SQL, Oracle Database Developer

Responsibilities:

• As database developer, developed Procedures, Functions and tables for Order Management System.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
• As a database designer, designed the db schema using Erwin and wrote the script to create the tables, sequences, constraints for Order Management System database.
• Designed and created different ETL packages using SSIS from Oracle source to SQL Server as destination.
• Developed Test Scripts based on SSIS packages and mapping documents.
• Designed ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Data Warehousing, OLAP tools.
• Worked with scheduling and publishing of reports in SQL server reporting services and integration with Microsoft Office tools like automatically emailing reports in various formats such as Excel, PDF etc.
• Used many transformations and the concept of check points while gathering the data from different sources in SSIS packages.
• Created entity/ process association matrices, entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Prepared Technical Documentation, this includes Data Model, Data Flow Process and Batch Database Processes.
• Optimized the session parameters as well as intelligent index creation and dropping scripts along with updatestatistics to have an efficient data load process.
• Worked in the role of a Business Analyst on the Data warehouse Project. Participated in database design and modeling sessions.
• Extensively used stored procedures, functions and triggers.

Environment: MS SQL Server 2005, SQL Server Integration Services (SSIS), SSAS, SSRS, T-SQL, OLAP Services, Oracle 9i/10g, .Net, XML, Windows 7, UNIX, Shell Scripts, Perl Scripts, TFS, and SharePoint.

Confidential

Responsibilities:

• As a Litigation Attorney, dealt with several civil cases
• Present and summarize cases to judges and juries.
• Evaluation of facts, developed strategies and arguments in preparation for presentation of cases.
• Gathered the required facts, formulated defense to initiate legal actions, by interviewing clients and witnesses to ascertain the facts of a case.
• Interpret laws, rulings and regulations for individuals and businesses.
• Settled most of the cases before they reach trials were settled eliminating the risk and expense of trial.
• As a Litigation attorneys settled cases at different times during the life cycle of the litigation by acting as an interpreter in between parties.

Confidential

Financial Analyst

Responsibilities:

• Conducted quantitative analysis of financial data to forecast revenue, identify future trends, and assess risk associated with capital expenditures, acquisitions, and joint-venture projects for large real estate investment firm.
• Compiled and reviewed complex data to assess multimillion-dollar accounts and business units.
• Developed comprehensive reports, abstracts, and charts to present data and guide investment strategies.
• Performed ad-hoc analysis and reporting.