SUMMARY

• 8+ years of professional experience as a Business/ Data Analyst & Business Intelligence Analyst/Developer in various business domains like Finance, Mortgage, and Communication & Healthcare.
• Extensive experience in analyzing in huge data sets and data mining to identify patterns, trends etc.
• Excellent experience and knowledge in modeling concepts like Conceptual Data Modeling (CDM), Logical Data Modeling (LDM), Physical Data Modeling (PDM), Star Schema, Snowflake Schema, Fact & Dimension tables, OLTP and OLAP.
• Experience in data mapping from source to target database schemas.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Well versed in Normalization/de - normalization techniques for optimum performance in relational and dimensional database environments.
• Hands-on experience with several BI tools, Reporting tools and Analytic tools like OBIEE, SSRS, Business Objects, Cognos, Tableau, Hyperion, Microstrategy.
• Experience in Design, Development and Implementation of the enterprise-wide architecture for structured and unstructured data providing architecture and consulting services to Business Intelligence initiatives and data driven business applications.
• Deep understating of Metadata management, Master Data Management, Data Quality, Data Security, Data Governance & Data Stewardship.
• Extensive experience in writing complex SQL Queries in T-SQL, SQL Server and was involved in production support.
• Good Experience in analysis and resolution of bottlenecks for performance tuning and optimizing SQL. Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Facilitated and participated in JAD sessions and white board sessions to keep executive staff and the team members apprised of goals, project status and resolving issues.
• Worked with ETL processes to transfer/migrate data from relational database and flat files common staging tables in various formats to meaningful data.
• Served as liaison with offshore development, QA teams, systems analysts, data modelers throughout life cycle of the project.
• Knowledge in the ETL of data into a data ware house/date mart with Informatica and Data Stage.
• Extensive experience in designing and deploying data visualizations using Tableau.
• Excellent problem solving, troubleshooting and decision making skills.
• Created numerous Dashboards and Scorecards for enterprise summary level reporting using difference BI Tools.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS Access and flat files.Developing reports on SSRS on SQL Server.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.

TECHNICAL SKILLS

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Visual Studio, Crystal Reports, Business Object, OBIEE, Cognos, Hyperion

Programming Languages: Base SAS, HTML, XML

ETL Tools: Microsoft DTS/SSIS, Data Stage, Informatica Power Center

Database Design Tools and Data Modeling: MS Visio, ERWIN, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Databases: Microsoft SQL Server, MySQL, Oracle, DB2, Teradata, MS Access, Netezza

Business Tools: MS Project, MS Office Suite, Rational Suite, MS Excel

Visualization Tools: Tableau Desktop, Tableau Server, Tableau Reader

Operating Systems: Microsoft Windows 95/98/2000/XP/Vista and UNIX, LINUX, Mac OS X

PROFESSIONAL EXPERIENCE

Confidential, VIRGINIA BEACH, VA

SQL, PL/SQL, ETL AND SSRS DEVELOPER

RESPONSIBILITIES:

• Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of data warehouse.
• Involved in reviewing business requirements andanalyzingthe data from various data sources for design, development, testing, and production rollover of reporting and analysis projects.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations like aggregator, expression, joiner, router, lookup, sorter, filter, union, update strategy, sequence generator using Informatica.
• Created and scheduled Sessions and Workflows through theInformaticaWorkflow Manager.
• Developed a Batch file to archive the bad files. All the batch files that are developed reside on the machine where Informatica server was installed.
• Participated in Technical and Code review meetings as the mappings are developed and tested.
• Build common exception handling process to enable verification and validation capabilities and provide necessary audit.
• Worked on Reports (SSRS) with respective to various markets.
• Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager.
• Generated SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports.
• Created different Parameterized Reports like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal and default like queried and non-queried.
• Created Linked reports, Ad-hoc reports based on the requirement. Linked reports are created in the Report Server to reduce the repetition in the reports.
• Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Created Stored Procedures to validate the data coming with different data discrepancies using data conversions.
• Created sub reports, bar chart, matrix reports, Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports for newly created Markets.
• Documented all the technical modifications.
• Involved in whole Agile process and Subversion.
• Worked on production support and testing environment to ensure it’s according to the business rules, developed reports and involved in testing and deployment.
• Created complex Stored Procedures, User Defined Functions, Triggers, Cursors, Tables and other SQL Joins and Statements by using T-SQL, SQL Server and PL/SQL.
• Used SQL profiler and Execution Plan to view index performance and thereby eliminate table scan.
• Involved in regression testing, and optimization of the query.
• Test reports to ensure accuracy, remediate defects and developed rollout plan with business partners.

ENVIRONMENT: SQLServer 2008 R2/ 2012, Oracle, PL/SQL, MS Visual Studio, Business Intelligence Studio (SSRS), Informatica, T-SQL, MS Excel.

Confidential, SAN DIEGO, CA

REPORTING DATA ANALYST

RESPONSIBILITIES:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Involved in reviewing business requirements andanalyzingthe data from various data sources for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, andviewsand other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Developed complex mappings inInformaticato load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure and Router.
• Designed and developedInformatica mappingsfor data loads and data cleansing.
• Interacted with business users and team leads in correlating business specification, Identifying data sources and Development strategies.
• Created dashboards according to user specifications and prepared stories to provide an understandable visualizations.Involved in new KPI generation for Scorecards.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters and parameters.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Making projections using forecasting models using table calculations like moving average, year over year growth, running total and percent of total and predicted the data for all transactions using trend lines.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server, T-SQL, PL/SQL and MS Excel.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Responsible for suggesting measure. Involved in developing cost analysis & optimizing models and budgeting.
• Reviewed basic T-SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Performed Performance Tuning and production support to resolve the bottlenecks.
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Test reports to ensure accuracy, remediate defects and developed rollout plan with business partners.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

ENVIRONMENT: TableauDesktop,TableauServer,MS Office Suite,Oracle, SQL Server, T-SQL, DB2, Cognos, MS Excel and Informatica.

Confidential, BELLEVUE, WA

BI DATA ANALYST

RESPONSIBILITIES:

• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Workedon designing the OLAP systems for data mart applications using SQL Server Analysis.
• Created SSIS Packages using Pivot transformation, Fuzzy lookup, Derived columns, Condition split, Aggregate, Multicasting, Execute SQL task, Data flow, Control flow, Containers and Data conversion etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Designed Data flows, Workflows and jobs to load data from source to target.
• Worked on daily batch loads like Full & Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Worked onError HandlingandLoggingin SSIS packages.
• Enhancing and deploying the SSIS packages from development server to production server.
• Designed and built OLAP cubes to meet reporting needs.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Identified fact, dimension tables and designed Data-Mart using Star Schema inSQL Server Analysis Services(SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
• Created and Designed Data Source and Data Source Views and also configured OLAP Cubes (Star and Snow flake Schema) using SSAS.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Designed Dimensional Modeling using SSAS cubes for End-User. Created Hierarchies in Dimensional Modeling.
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs and deployed cubes.
• Created reports in SSRS with different type of properties like chart controls, filters,Interactive Sorting, SQL parameters etc.
• Created reports from OLAP, sub reports, bar chart, matrix reports, Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Successfully created Snapshots Report, Report Subscription, Data Driven Subscriptionand Report caching using Report Manager.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Use statistical and analytical skills to produce analyses in managing the business and making business decisions.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Performance Tuning and Production Support of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

ENVIRONMENT: MS SQL Server, T-SQL, SSRS, SSAS, SSIS, ODBC, Erwin, MS Visual Studio, Microsoft Excel, Business Objects, OLAP, OLTP, Access.

Confidential

BUSINESS DATA ANALYST

RESPONSIBILITIES:

• Facilitated JAD sessions to bring business requirements and functionality into system development and enhancement.
• Documented the Business requirement documents (BRD), System requirement document (SRD), and produced the Data flow diagrams (DFD), Bus Matrix .and Requirement Traceability Matrix.
• Actively prioritized and managed requirements throughout SDLC with all key stakeholders.
• Worked on daily batch loads like Full & Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Worked on complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Developed SSIS packages using various transformations such as Conditional Split, Fuzzy Look Ups, Aggregations, and Multicasting.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Developed complex mappings inInformaticato load the data from source tables using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Stored Procedure and Router.
• Implemented Slowly Changing Dimensions Type 1, Type 2 and Type 3.
• WroteTest Casesfor testing each of the interfaces which were used by the QA team.
• Performance Tuningby determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Worked on production support and testing environment to ensure it’s according to the business rules, developed reports and involved in testing and deployment.
• Created ad hoc reports, chart reports, tabular and matrix and parameterized reports using Report Builder 3.0.
• Used BIDS to create parameterized reports and created several Excel reports using cube data
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements.
• Performed data analysis to identify/ validate the data for accuracy, quality and integrity. Wrote and ran various SQL queries against Teradata, Netezza, &SQL Server and T-SQLto critically evaluate test results and performed Performance Tuning/ Production Support to identify bottlenecks.
• Produced source to target data mapping and data definition document.
• Involved heavily in testing the reports and dashboard results by writing extensive SQL queries to check against the business requirements.

ENVIRONMENT: Microsoft Office Suite, Oracle, SQL, SQL Server, SSRS, SSAS, SSIS, T-SQL, Teradata, Netezza, Quality centre, Hyperion, OBIEE, JIRA, Informatica.

Confidential

DATA ANALYST

RESPONSIBILITIES:

• Facilitated JAD sessions to determine data rules and conducted Logical Data Modeling (LDM) and Physical Data Modeling (PDM) reviews with Data SMEs also participated in data analysis and data dictionary and metadata management.
• Worked on data modeling and produced data mapping and data definition documentation, Used SAS import procedure to generate temporary and permanent SAS data sets from txt, csv and excel data sets.
• Performed Data Requirement Analysis and developed Use Cases, Activity Diagrams, Data flows.
• Gathered user requirements for new reports through JAD/JAR sessions, which eliminated duplicate and obsolete data and provided a uniform reporting environment across the multiple trading desks.
• Worked on Field analyzing like identifying the business logic for each field, Participated in team meetings and proposed ETL Strategy. Worked on documenting solution and detail documents for the High-level Design Specifications for ETL Coding and mapping standards.
• Involved in ETL processes like Informatica and SSIS to apply necessary transformations and remove the duplicate data and correct the data and finally load it into the destination.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations like aggregator, expression, joiner, router, lookup, sorter, filter, union, update strategy, sequence generator using Informatica.
• Setup folders, groups, users, permissions and performed Repository administration using Repository Manager and responsible for Error Handling and bug fixing.
• Wrote PL/SQL Procedures fordata extractions,transformationandloading.
• Created SSIS Packages using Pivot transformation, Fuzzy lookup, Derived columns, Condition split, Aggregate, Multicasting, Execute SQL task, Data flow, Control flow, Containers and Data conversion etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed SSIS packages with error handling and deployed them on to the QA and production server.
• Generated SSRS reports which included various reporting features such as groups, sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals, drilldowns, drill through, sub-reports, navigation reports.
• Created Linked reports, Ad-hoc reports based on the requirement. Linked reports are created in the Report Server to reduce the repetition in the reports.
• Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Actively involved in Performance Tuning and Production Support to resolve the bottlenecks.
• Ran various T-SQL and SQL queries to evaluate the test results.
• Facilitating JAR sessions for gathering reporting requirements and defining the user acceptance test standards.
• Skilled at transforming customer requirements into high quality end products via cost effective Lean/Agile processes employing continuous process improvement initiatives across business units.
• Worked with the developers to create Data Mapping Documents. Mapping required fields off the customer reports to the source tables.

ENVIRONMENT: Oracle, Teradata, Business Objects, Informatica, SSIS, SSRS, T-SQL, SQL Server, Microsoft Office suite, SAS.