SUMMARY:

Skilled at helping to meet client’s goals by applying analytics that utilize understanding of businesses, products and industry. Involved in developing business requirements, application design, data modeling (Star, Snow Flake schema, Facts and Dimension tables) using Erwin. Develop SAS programming, SAS Macros, SAS Data warehouse and analysis. Proven ability to solve problems through quantitative analysis, using statistical methods in large databases in multiple platforms. Proven Apps System Engineer involved in developing converting VB6 codes to C# in .Net environment. Expert knowledge of object - oriented analysis/design, object-oriented development methodologies, distributed applications. Goal-oriented, self-starter knowledgeable in all phases of entire product life cycle including development, design, debug, test and documentation. Demonstrate exceptional problem solving and strategic thinking skills under tight time constraints. Expertise in:

TECHNICAL SKILLS:

ETL:  Power Center 9.5, SSIS, SSRS, SSAS, SQL Server DTS and SAS 9.0, BO

Software:  Java, Visual Basic, C#, SQL, PL/SQL, TSQL, HTML/XML, JavaScript

Databases:  DB2, Oracle 11g, MySQL, SQL Server 2008 and 2012, Access, RDBM, TOAD

Operating Systems:  UNIX, LINX, Windows

Version Controls:  TFS, SharePoint, SVN, ClearCase

Infrastructure: .Net, J2EE, JCL, CICS, E-Commerce, Web Sphere, Web Logic

Server:  Windows / NT, AS400, UNIX Server, Apache Server, SQL Server 2008, 2012

SAS Tools:  SASV9, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/STAT, SAS/ODS

Ancillary Skills: Excel, PVCS Tracker, Requisite Pro, Win SQL, DB Visualizer, iSeries Navigator

PROFESSIONAL EXPERIENCE:

Confidential, IL                                 

Lead BI Developer                                      

Responsibilities:

• Act as Lead BI Lead, with expertise in elicit and validate requirements to & form the required business process at the application level.
• I nvolve in organizing, updating all existing data models, data flows and data dictionaries into a Metadata Repository in order to accommodate new requirements to make sure it will not impact existing functionalities.
• Expert in creating SSIS packages using verities of source files. Expertise in enhancing and deploying the SSIS Packages from development server to production server.
• Build the Metadata model & Business Glossary by gathering information from multiple sources: business users, existing data sources, databases and other relevant documents and systems.
• Involved in Data Warehouse Process involved in Analysis, Design, Development of various business applications, different platforms using Informatica Power center 9.5.1.
• Develop and administer tasks and assignments primarily accomplished using the Business Objects tool suite.  Designs, builds, tests, and documents moderately to highly complex Business Objects reports and universes, in addition to assisting with deployment and maintenance tasks.
• Expertise in optimizing the session performance by eliminating performance bottlenecks by optimizing target, source, mapping, transformations, session, grid deployment and optimize the system 
• Expert in creating SQL Server Reports using SSRS 2008, 2012 in designing stylish report layout parameterized, Chart Reports, Ad-hoc reports, Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports. 
• Participate in requirement gathering, cube design, application design, SSAS development, training operational users
• Experience in Logical modeling using the Dimensional Modeling techniques such as Star Schema and Snow Flake Schema. Experience in creating multidimensional cubes using SSAS and OLAP (Creating Cubes) includes interfaces with SSDT. 
• Implement SQL Server OLAP services (SSAS) for building the data cubes.
• Involve in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Define MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes

Environment: Power Center 9.5.1, Java, J2EE, BO, PL/SQL, TSQL, SQL Server 2012, ALM, STARTeam, UNIX

Confidential,IA         

Apps System Engineer / ETL Developer          

• Worked with mortgage and retail business applications within the Confidential that supports multiple loan applications. Involved in Converting VB6 apps to C# codes in .Net environment.
• Working with different source systems like SAP (R3), AS400, flat files, Oracle. Contacting the Business Analysts/Users to develop, document and develop data models based upon their input and feedback.
• Built reports by using SQL Server 2008 (SSIS, SSSR, SSAS) scope with various requirements provided by the business and management.
• Prepared ETL design document which consists of the database structure, change data capture, Error handling, restart and refresh strategies. Created mapping for creating a parameter file. Assisted business users for data cleansing and user acceptance testing.
• Developed and tested extraction, transformation, and load (ETL) processes. Created sessions and workflows for the source to staging data flow from staging to Target loading.
• Developed functions and stored procedures to aid complex mappings. Proactively worked in developing C# application by converting code from VB.Net application in order to upgrade existing application to standard system.
• Involved in developing a Web based reporting tool build on .Net framework called ‘PRISM’(a proprietary application within the Confidential ), that has UI interface in which selected users can run different reports selecting from drop down menu. The backend data preparation (report generation) is handle by SQL Server stored procedures.
• Involved in creating TSQL Store Procedures that triggers at the backend to collect the data from multiple sources in order to generate report from UI interface of the ‘PRISM’ portal.
• Supported other legacy applications issues in which applications were built in COBOL and ACCESS databases.
• Participated in requirement gathering, cube design, application design, SSAS development, training operational users. Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes

Environment: C#, J2EE, .Net, SAS, PL/SQL, VB6, SQL Server 2008, UNIX, AS400

Confidential, IA                

ETL Developer / Database Analyst                

• Analyzed existing operational data sources and involved in development of the logical and physical data models for newly build Data Warehouse. Scoped the business system & model, translated business needs & technical issues, modeled &translated technical requirements & issues.
• Designed and developed ETL (Informatica Power Center 9.1) packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Developed database objects and processes to consolidate data from multiple databases including Teradata, Oracle, SQL Server, and DB2. Data mining from multiple systems such as SQL Server, DB2, Oracle and Teradata. Worked with business analysts in group to define and build business rules within database model.
• Developed UNIX scripts to perform operations bringing source files from staging area to the UNIX source directory and triggered Power Center workflows archiving the files and updating the necessary log files on the operations performed.
• Worked on SAS/Base, SAS/Stat, SAS/Access, SAS/Graphs, and SAS/Macro; optimized performance using Data Validation and Data Cleaning using Statistical procedures like PROC FREQ, PROC MEANS.
• Performed tuning of the Informatica mappings using Parameter files, Variables and Dynamic cache. Use Shell scripts for scheduling data cleansing and loading process. Maintain batch processes using UNIX shell scripts.
• Build efficient ETL packages for processing fact and dimension tables with complex transformations and type 1 and type2 changes.
• Analyzed, programmed and created reports on existing strategies using SAS and TSQL. Designed, implemented, tracked performance trend on new strategies in a test vs. control environment.
• Participated in requirement gathering, cube design, application design, SSAS development, training operational users. Implemented SQL Server OLAP services (SSAS) for building the data cubes.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Defined MDX scripts for querying the data from OLAP cubes (SSAS) and build reports on top of cubes

Environment: C#, J2EE, .Net, SAS, Power Center 8.6, TSQL, Visual Studio 2008, SQL Server 2008, UNIX , TFS