SUMMARY

• Professional experience as Sr. business/data analyst, reporting analysis, and project management in software industry including analysis, design, development, testing and documentation of software applications of different sizes and industry domains.
• Hands on BI reporting tools as Informatica, microstrategy for various healthcare, retail and Pharma projects.
• Hands on data modeling, data mapping and UML diagramming of multiple projects, which involves PL/SQL as databases.
• Extensively experience in various versions of Informatica ETL, Power Center (Source Analyzer, Mapping Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/SQL Server Manager).
• Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Senior QlikView BI with comprehensive experience in planning, designing and building BI Dashboard and Analytics Reporting solutions, utilizing BI tools (QlikView, BO, SSIS/SSRS), Databases (Oracle, DB2, Microsoft SQL, IBM Netezza), data analytics and dashboard visualization skills, supporting evidence - based business decision-making.
• Extensive Working knowledge on Data Modeling, Data Conversions, Data integration and Data Migration with specialization in Informatica Power Center and Erwin.
• Experience in Extraction, Transformation, and Loading (ETL) data from various sources including Mainframe Legacy Systems into Data Warehouses and Data Marts using SSIS.
• Exposure in Extracting, Transforming and Loading (ETL) data from other databases and text files.
• Experienced in using reporting tools: MS Access, Business Objects Web Intelligence and Crystal Reports.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Experience in installation, configuration, and migration of Business Objects XI R2 using CCM, CMC and Info view.
• Hands on Business Intelligence (BI), ETL, Informatica and Microstrategy for different datawarehouse projects.
• Good experience in creating new filters in OBIEE as per requirements of new reports.
• Experience in Business Intelligence testing in various reports using Business Objects, Crystal Reports and Crystal Dashboards (Xcelsius).
• Experience in working with Data Warehousing and business intelligence tools for developing various reports using QlikView.
• Performed PL SQL, SQL Server Management and Administration Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Good command over Logical and Physical entity relationship data modeling using Erwin, Oracle Designer and Power Designer.
• Experience in OLAP universe designing, well versed with Business Objects XI 4.0/4.1, Web Intelligence, Crystal Reports, Dashboard designer (XCELSIUS).
• Experience in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Experience in creating SSIS packages applying various data transformations and migrating data from various data sources.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Hands on development experience on SQL Server 2008 & 2005 SSRS Reporting Services, SSIS, DB2 UDB, Data modeling, Crystal Reports, UNIX shell scripts.
• Experience in creating QlikView access point for client application rollout and administrator security by Active Directory technology using QlikView Publisher.
• Experienced in implementing Business Intelligence Solutions for Enterprise Decision Support solutions using SSIS, create PL SQL server side reporting solutions using SSRS, and data analysis solutions using SSAS.

TECHNICAL SKILLS

Methodologies: SDLC, Agile, Scrum, and Waterfall

Languages: Java, .NET, Javascript

Databases: SQL, PL/SQL, MS Access, Oracle, Oracle 10g, 9i

Applications: MS office, Data Warehousing, BI, ETL, Informatica, Microstrategy

Tools: Business Objects 6.1B Reporting, OBI, Crystal Reports, SSIS, SSAS, SSRS, Qlik View, Tableau

Operating Systems: Windows, Linux, Mac OS, UNIX, and Red Hat

Documentation: BRD, FRD, SRS, DFD, Requirement Gathering and UML

PROFESSIONAL EXPERIENCE

Business Intelligence Data Analyst

Confidential -Richmond, VA

Responsibilities:

• Working with various views like view selectors, column selectors, table view, pivot table view, etc.
• Load and extraction programs involving HIPPA 837 and proprietary format files and Reports development.
• Working with the BA to come up with test case scenarios, and work with CMS data.
• Involved in the full HIPAA compliance lifecycle from GAP analysis, mapping, implementation, and testing for processing of Medicaid Claims.
• Responsible for physical/logical data modeling; metadata documentation; user documentation; and production specs.
• Taking responsibility to implement the informatica module of the project.
• Preparing the detailed analysis document of the informatica workflows degrade in performance.
• Improvement on summary processes from others and implemented time savings in performance tuning SQL.
• Creating tables, indexes, and primary keys for new table structure needs for the business.
• Building new reports in SSRS and stored procedure output reports.
• Meeting with the users to show them what the OBI tool can do, how the OBI reports will differ from BI.
• Publisher reports, and advising the user on how the OBI tool can enhance their reporting.
• Doing Gap Analysis on what was needed to build reports per the user requirements.
• Assisted in training the end users on how to access the BI launch pad, how to create simple reports using WEBI/Crystal Reports, introducing them to Dashboards and explaining the benefits of the powerful tool.
• Involved in Business Intelligence reports development efforts by working closely with Teradata, and ETL teams.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Performed In-Death analysis of systems and business processes of Medicare Part D as per CMS rules and procedures.
• Expertise in creating mappings, PL-SQL mapplets and reusable Transformations using Informatica Power Center Designer.
• The reports are built using Webi Rich Client and exported to CMS and scheduled instances of WEBI report in Infoview.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 8.5.
• Created Dashboards style of reports using QlikView components like List Box, Slider, Buttons, Charts and Bookmarks.
• Built business requirements into the Medicare Advantage (MA) requirements database and created the Project Requirements Document for the three functional areas.
• Importing new tables into physical layer of Oracle BI Admin Tool according to new business requirements.
• Experience working with HIPAA 4010A and HIPAA 5010.
• Modifying existing BMM layer by mapping columns from Physical layer to BMM layer.
• Rearranging columns in Presentation layer to order and organize columns in analytics.
• Schedule Business Objects reports through info view and CMC.
• Created the reports using Business Objects functionalities like Combined Queries, Drill down, Cross tab, Master detail and Formulae.
• Modifying existing logical columns and created new logical columns using CASE Statements
• Altering existing OBIEE reports as per the new requirements.
• Coordination and work along with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Altering existing dashboard prompts in OBIEE Analytics/Answers according to new business requirements
• Creating pivot tables in OBIEE Analytics according to new business requirements.
• Set up groups and users for Business Objects deployment and managed user profiles using CMC.
• Providing DBAs with back end SQL queries extracted from OBIEE for performance tuning
• Modifying existing columns in report tables according to new business requirements
• Renaming columns, reformatted columns and hid columns in OBIEE reports as per new business requirements
• Using time functions in OBIEE reports for calculating the time gap between two date columns

Business Intelligence Data Analyst

Confidential

Responsibilities:

• Worked with business analysts and Sr. engineers in analyzing business requirements.
• Generated technical documents about database/data warehouse structures and functional specifications.
• Designed and developed SSIS (ETL) packages for loading data from Oracle, Flat and Access files to SQL Server Database.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Understood OLAP processing for changing/maintaining Warehousing, Optimizing Dimensions, and Hierarchies.
• Generating reports, managing inventory and operations, with Microsoft Dynamic
• Applied various transformations like conditional split, look up, fuzzy lookup, fuzzy group, derived column, merge, multicast, sort, union all and so on.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer
• Scheduled jobs to call the packages and Stored Procedures using SQL Server Agent.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed reports out of the consolidated data warehouse for the business users using MS SQL Server Business Intelligence Development Studio.
• Created different SSRS Reports based on the user's requirements, such as Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Developed Reports for business end users using Report Builder tool and SSRS Report Manager.
• Utilized Tableau and Qlikview to generate appealing visual reports, including maps, charts, histogram, bubbles, and dashboard.
• Deployed the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report and gave roles, user access with respect to security in Report Manager.
• Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.
• Conducted and monitored database management by using SQL Profiler, Database Engine Tuning Advisor and Index Tuning Wizard.
• Created complex queries such as all kinds of joins (Left join, Right join, Full join, Outer join), CTEs, and sub queries using T-SQL.
• Created Stored Procedures and Triggers for data retrieval used in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Involved in creation of performancepoint dashboards; Published dashboards to SharePoint
• Supported troubleshooting with BI tools, systems, and software; performance-tune these applications as necessary.
• Involved in training the End users on how to use the tool.

Business Analyst

Confidential - Chicago, IL

Responsibilities:

• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Created new SSIS packages to extract, transform and load data from one database to another and from OLTP to OLAP using various tasks like execute SQL task, data flow task, and file system task; SSIS transformations like, conditional split, data conversion, aggregate, derived column, merge, script component, SCD (slowly changing dimensions) and so on.
• Created database objects like tables, indexes, views, user defined functions and stored procedure for data migration using SQL server.
• Filtered bad data using complex T-SQL statements, UDFs and implemented various constraint and triggers for data consistency.
• Created complex queries such as all kinds of joins (Left join, Right join, Full join, Outer join), CTEs, and sub queries using T-SQL.
• Created Stored Procedures and Triggers for data retrieval used in SSRS.
• Created or modified many ETL transformations such as, format revisions, look up, handing of null values, decoding fields, merging of data, character set conversion, deduplication and so on.
• Created various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views for data manipulation.
• Used common table expressions and temporary tables in various stored procedures; created various scalar functions and table valued functions
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in SQL Server 2012.
• Created different SSRS Reports based on the user's requirements, such as Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Developed Reports for business end users using SSRS Report Manager, Report Builder tool, Tableau and Power BI.
• Deployed the generated reports on to the server by configuring Report Service Configuration Manager and established credentials to access or deploy a report and gave roles, user access with respect to security in Report Manager.
• Managed index statistic, Tables, Views and optimized queries by using execution plan for tuning database; Used SQL Profiler to collect the workload and updated clustered and non-clustered indexes.
• Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Created SSIS packages with Logging and Event Handling with Text File/SQL Server Log Providers under predefined events such as OnError, OnPreExecute, OnTaskFailed and OnPostExecute.
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Production Environments.
• Supported troubleshooting with stored procedures, and SSIS packages as needed; properly documented ETL processes for future reference.
• Involved in creating different SSRS Reports based on the user's requirements, such as Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services.
• Helped developing the T-SQL queries used in drill down reports in SSRS.
• Generated technical documents about database/data warehouse structures and functional specifications.
• Assisted in troubleshooting for the existing reports as needed.