PROFESSIONAL SUMMARY:

• 15+ years of experience in handling medium to large scale projects catering to the needs of the clients with standalone, client server platforms using SQL Server (SSIS, SSRS, SSAS), Oracle, Teradata, DB2, Database.
• Proficient in all phases of system design, development, unit and integration testing, and implementation. Strong Experience in analysis, design and in customizing commercial applications and standard business aspects.
• Extensive knowledge of technologies with changing time like SOA/RESTful WebServices, Agile Integration, Hadoop, Map/Reduce, Hive, Pig, Sqoop, Cloud Technologies like Azure, AWS, Hortonworks, Cassandra.
• Responsibilities include system study, elevated level and low - level design, database planning, client-server implementation, ERP Packages, SAP Sales and Finance Modules, GUI development, and Report development.
• Wrote Several Database Procedures, Functions, Triggers, SSIS Packages using SQL, PL/SQL. Developed Queries for Informatica Power Center, Datastage, Talend, Business Objects Designers Universe and Reports.
• Worked extensively on Data Migration, Extractions, Transformation, Loading and Data Warehouse design with Universal Database (DB2), Oracle, SQL Server. Developed ETL Mappings, Jobs and Reports. Created ETL jobs using SSIS, Datastage, AbInitio, Informatica and SSRS, Business Objects, Cognos Reports.
• Expert level programming skills in Oracle11g, SQL*Plus, PL/SQL, Datastage, Informatica, SAP BW, Business Objects, Cognos, SAS, SPSS, JMP, Talend, Tableau, QlikView, BIRT, Java, JavaScript, HTML.
• Skilled in planning, designing, developing and deploying Data warehouses / DataMarts with experience of both relational & multidimensional database design using ERWin (Physical and Logical data models).

TECHNICAL SKILLS:

Operating Systems: UNIX, Sun Solaris, RedHat, Windows10, IBM, Apple OS, Android.

Programming Languages: Java, J2EE, EJB, Pro C, C/C++, COBOL, SQL, PL/SQL, XML, JSON etc.

Databases: Oracle, SybaseIQ, Neteeza, TeraData, SQL Server, DB2, MySQL

Scripting Languages: J2EE, STRUTS, Hibernate, Web 2.0, JAVA Script, PowerShell, Bash Shell

GUI Tools: Rapid SQL, SQL Designer, TOAD, Tivoli, Autosys, Control-M, BTEQ

CRM Tools: SalesForce, Siebel (SFA, Marketing, CTI), PeopleSoft, SAP CRM

ERP Packages: SAP (Sales, Marketing, Supply Chain), Oracle Packages (Financial, HR, SOA)

Application Servers: Websphere, WebLogic, Portal, Ajax, Hibernate, Tomcat, Apache, IIS

Big Data Tools: Hadoop, Hive, Sqoop, Hbase, Map/Reduce, Cassandra, MongoDB, Greenplum

Cloud Technologies: Microsoft Azure, Amazon Web Services (AWS), Cloudera, IBM Bluemix

BI/Reporting Tools: MS PowerBI, Cognos, TM1, Report Studio, Query Studio, Framework Manager, MicroStrategy, Actuate, Jaspersoft, Tableau, QlikView, Oracle BI

ETL/Data Warehousing: SSIS/SSRS/SSAS, Informatica PowerCenter, Power Exchange, Data Quality, Datastage, AbInitio, SAS, Business Objects, Pentaho, Talend Tools

Other Tools: Share Point, Subversion (SVN), JIRA, VSS, TFS, GIT/HUB, Humming Bird

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Architect /Lead Developer

Responsibilities:

• Lead project kick off meetings, business requirement gathering with product managers, business sponsor. Maintain an effective communication channel with the Project Managers, Business Analysts, Developing Teams.
• Experience in developing Multidimensional Data Model, designing logical and physical modeling, data warehouse architecture for EDW, ODS, OLTP, OLAP & MDM, Data Quality, analyzing user requirements.
• Building Dimensions and Facts like Portfolio, Assets, Trades, Securities, Transactional Fact, Holdings Daily Fact, Holdings Monthly Summary, Real Estates, Profit/Loss Details, Ledger Details, Date Dim etc.
• Leading Team of Developers, developing Architectural Design documents, Analysis of Source--Target systems, writing scripts in JSON, XML, Parsing XML to load data in SQL Server and building XML and JSON files.
• Used Microsoft SSIS Designer in Visual Studio, Management Studio for Developing Mapping, Data flows, Control Flows. Supported API calls using REST, SOAP, XML, JSON for Web Services and Cloud applications.
• Used Microsoft SQL Server Integration Services Designer to create Mappings, Dataflows, JobAgents. Developing SSIS packages for moving data from Cloud to on premises for reporting and Analytics teams.
• Setup Azure Portal, User Permission, Subscription, SQL Server Virtual Machines, Scaling Clusters, Nodes Servers, Sequential/Parallel Process with Hive, Hue, Hbase, Pig, Map/Reduce, Spark/Kafka scripts.
• Developed Microsoft Cloud Azure SQL DB and Tables, Azure Data Factory Pipelines, HDInsights, Data Lakes move data within Cloud environment, Implemented Security with Azure AD, AzCopy to Extract/ Load.
• Enforce Best Practices, Agile/Scrum principles and ETL standards. Perform analysis and capacity planningfor ETL solutions. SME in developing, designing OLTP/OLAP systems and writing technical docs.
• Defined Table Structures, ER Diagrams, Parameters Sets, Data Connections, Transform Logics/Condition for Sequential/Parallel Process with SQL, PL/SQL, Lookups, Filters, Joiners, Aggregators, SCD, CDC maps.
• Used SSIS, SSRS, SSAS, Data Integration Services for Business Rules, Address Cleaning with Melissa DQ, Tableau Reports for Daily Sales, Commision reports, Monthly Dashboards, Scorecards and DQ reports.
• Working with Team developing Architectural Design documents, Analysis of Source/Target systems, writing scripts in Spark, Python, data in NoSQL DB like Cloudera and building Data Sets/Frames, Parquet/Avro files.
• Used ERWIN to create Physical/Logical Models, Canonical Data Model, OLAP DataMarts using Star Schema. Developed Filters, Calculations, Conditions, Graphs, Trends and Prompts in reports, complex interactive/dynamic dashboards with drill down capability using Azure SQL Tables, Azure AD, PowerBI.
• Preparing details documents like business process flows, data flow diagrams, best practice guidelines describing project phases and tasks, deployment scenario for the successful implementation of the project in Production.

Environment: Microsoft SQL Server, Azure Cloud DB, AzCopy, DataFactories, HDInsights, XML, JSON, SalesForce, SSIS, SSRS, SQL Server, TFS, JIRA, GIT/HUB, Tableau Reports, Windows, UNIX Scripts.

Confidential, Chicago, IL

Architect /Lead Developer

Responsibilities:

• Experience in developing Multidimensional Data Model, designing logical and physical modeling, data warehouse architecture for EDW & MDM, Data Quality, decision making and analyzing user requirements.
• Design, build and deploy extract-transform-load (ETL) mappings using Microsoft SSIS Parallel Process, Sequential Process, SQL, PL/SQL, Stored Procedures, Lookups, Filters, Joiners, SCD, Change Data Capture.
• Developed Microsoft Cloud Azure Blob DB, HDInsights, Azure Data Factory Pipelines, Data Lakes to move data within Cloud environment, Implemented Security with Azure AD, AzCopy to Extract/ Load data.
• Used Microsoft SSIS Designer in Visual Studio, Management Studio for Developing Mapping, Data flows, Control Flows. Supported API calls using REST, SOAP, XML, JSON for Web Services and Cloud applications.
• Used SSIS, SSRS, PowerBI, Data Integration Services for Business Rules, Address Cleaning with Melissa DQ, SAS Reports for Daily Sales, Commission reports, Monthly Dashboards, Scorecards and Data Quality reports.
• Created and Developed SSAS Analysis for Customers, Orders, Accounts, Marketing, Affiliates, Products, Restaurants, Sales Subject Areas. Working with DevOps, Operational, Business and Sales/Marketing Teams.
• Architect, create and build efficient programs to execute ETL Mappings and Workflows in Visio. Created SQL Agent Job for automation with Powershell Scripts, Migration to Unit Test the jobs in DEV, FQA, PROD.
• Developed SOA Architect Design for ETL and Reporting to extract data from Legacy DB to Cloud database, transforming into ODS and into OLAP, MySQL, Enterprise Datawarehouse (EDW), CRM(SalesForce).

Environment: Microsoft SQL Server, Azure Cloud DB, DataFactory, XML, JSON, SalesForce, Visual Studio, SSIS, SSRS, SSAS, SAS, SQL Server, TFS, TOAD, JIRA, GIT/HUB, Share Point, Windows, UNIX Scripts.

Confidential, Rosemount, IL

Technical Lead / Data Modeler

Responsibilities:

• Analyze technical needs, Designs, requirements, and state of the client’s infrastructure design, integration, and operations with business analyst and ensure Functionalities, System Testing, User Acceptance Test, Migrations.
• Defined Table Structures, Souce/Target Mappings, Parametere Sets, Data Connections, Transform Logics/Condition for Sequential/Parallel Process with SQL, PL/SQL, Lookups, SCD, Change Data Capture.
• Developed Retail Logical Model (RLM) in Teradata with areas like STORE, ORGANIZATIONS, ADDRESS, PHONE, ITEM, SALES, ORDERS, HOUSEHOLD, CUSTOMERS, PROGRAMS, ACCOUNTS, REWARDS.
• Developed Data Migration jobs from SSIS to Informatica and Teradata Database. Created Models in ERWIN for Conceptual, Physical and logical Data Model. Used BTQ/Tload/TPT/ Muliload/ Fastload tools.
• Created/ Developed Applications, Sequences, Unix/Powershell Scripts in Control M for Automation and Code Migration using SVN, Sharepoint. Migrated Code, DDL, DML scripts to environment like DEV, QA, PROD.
• Experience in developing Migration rules both in AbInitio and Informatica Data Quality and Profiling, Multidimensional Data Model in Terradata for EDW & MDM, maintaining data quality and user requirements.
• Defined File/Tables Structures for Hadoop, Star Schema, Relation Diagrams, Data Connections, Transform Condition for Sequential/Parallel Process with Teradata, BTEQ, TPT, MLoad, TLoad and QlikView reports.
• Developed reports in SSIS/SSRS Dashboard, pie charts, bar charts, histogram, Heat map and Box charts. Administration for user permissions AD/LDAP/SSO, Management console, Project setup. Used Tableau/Alteryx Analytical tool Installation, App Permission, Administration, help SAS Analytical reports.

Environment: Microsoft SQL Server Integration Services, SSRS, SSAS, Data Quality Designer, Web services, Azure DB, Sharepoint, TFS, XML Erwin, Java Scripts, Teradata, BTQ, TPT, GIT/HUB, Windows/Unix

Confidential, Chicago, IL

Data Architect/ Sr Lead ETL Developer

Responsibilities:

• Experienced working in a team environment providing technical leadership, business requirement gathering, specification creation, solving Data Quality, reporting problems, co-ordinating Offshore and Onshore Teams.
• Defined Table Structures, ER Diagrams, Parametere Sets, Data Connections, Transform Logics/Condition for Sequential/Parallel Process with SQL, PL/SQL, Lookups, Filters, Joiners, SCD, Change Data Capture.
• Created Physical and Logical Design for CAL database with tables for Valuation and Transaction details like VLN AC SUM, VLN SEC, VLN CURR, VRP AC SUM, VRP POSN, VRP PHYS HLDG, TRN HDR, TRN XREF, TRN CASH, TRN FORGN EXCHG, TRP HDR, TRP XREF, TRP EXTL REF, APR EXCH RT, ASM CUST AC, ASM AC, CFI CUST, FM NTRES FUND etc.
• Used IBM Infosphere Datastge Director, Designer to developed Parallel, Server, DataQuality, Routines, Shared Containers Jobs, Sequences using SQL, Stored Procedures, XML, XSD, Web Services integraton.
• Extracted Data from Mainframe DB2 server from Action Tables and Base Tables with Before and After Images of Inserts, Updates, Deletes. Implemented Change Data Capture on Mainframe with Datastage CDC.
• Used Control-M for scheduling Jobs and Sequences for Extract and Load in STAGE then to ODS. Written lots of Unix Scripts for automation of Datastage jobs, File checking, Archieving, Param sets, Log files etc.
• Developed reports for Business Objects, Webintelligence, MS SSRS/PowerBI, Tableau Analytics Dashboards using components for Alerts, Drill Downs, Report Behavior and report optimizing, publishing.
• Created List reports, cross tab, KPI reports and drill through reports, What If Analysis, complex Reports, Adhoc reports, Running Totals, Trends using Tabular Joins, SQL and Integrated with Web applications.

Environment: Microsoft SQL Server SSIS, SSRS, SSAS, Visual Studio, Business Objects XI/4.0, Windows.