Summary:

• EIGHT years of IT Industry experience in Software Development involving Analysis, Design, Development, working experience on MS SQL Server 2000/2005/2008, ETL Tool (Data stage),Business Objects Reporting, Physical/Logical design, T-SQL, Performance-Tuning, Troubleshooting, replication, Backups and Restore of databases with CMM level 5 standards company.
• Worked extensively in developing and implementing Crystal reports/WebI on Business Objects Enterprise XI R2 and XI 3.1, Crystal Enterprise 2008.
• Expert in creating complex crystal reports with over FIVE sub-reports, crosstabs, drill downs and more than 10 grouping sections, Webi reports from universes and excel reports sourced from SSAS cubes.
• Experience with Adhoc reporting, Parameterized, Custom Reporting using Business objects for daily reports.
• Expertise in building Dashboards using Business Objects Xcelsius. Experience in working with Voyager, Explorer and Information Spaces.
• Expert in Universe creation using Business Objects Universe Designer, Business Objects Information Delivery tool (IDT 4.0). Created Complex universes with multiple contexts and handled loops, Fan traps and Chasm traps.
• Expert in MS T-SQL, Data Stage ETL Tool, Data Cleansing and Data Migration. Transformed data from one server to other servers using Bulk Copy Program (BCP), Data Transformation Services (DTS) to load data into DataWarehouse and Data Marts environment.
• Excellent in High Level Design of ETL jobs for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Expertise in creating server and sequential batch jobs which will trigger the normal jobs on multiple conditions (wait for file, looping, to check replication latency is current, reading data from file and triggering the jobs based on the data read).
• Experience in Migration of Business Objects XI R2 to Business Objects XI R3.1. Experience in Migration of Business Objects XI R3.1 to Business Objects 4.0.
• Expertise in Data Modeling methodologies like star-schema, snowflake and relational databases using Visio, Erwin for creating new Data Warehouses and Data Marts.
• Experience in building SSAS Cubes and Dimensions with different Architectures and Data Sourcesfor Business Intelligenceusing SQL Server.
• Attended sessions to learn new features in SQL Server 2012 presented by Microsoft Consultants at Microsoft Technology Center (MTC), Dallas. Worked with Microsoft Consultants on performance improvement in SQL Server 2008 R2 using inbuilt partitioning.
• Attended sessions to learn new features in Business Objects Information Delivery tool (IDT 4.0) presented by SAP consultants.
• Familiar with Fragmentation and Query analyzer for SQL Server 2000/2005/2008 R2and experience with Database Tuning Advisor and SQL Profiler for tracing, auditing and Performance Tuning.
• Strong experience in writing stored procedures, functions, triggers in MS T-SQL building the packages, testing and implementing on production servers. Experience in interacting with business users and rules analysts on multiple projects.
• Expertise in Requirements Gathering and Analysis, Detailed Design, Design Review, Coding, Test plans, Integration Testing, Regression Testing, Reviewing coding standards and team co-ordination.
• Configuration controller and Defect Prevention Anchor for the Data Warehouse maintenance and enhancement project by following Infosys Software engineering processes.
• Highly motivated, committed and a natural team player with capability to work independently, Strong analytical ability coupled with excellent written and verbal communication skills. Liaising with Business Managers and users to gather requirements, collaborating between teams in offshore-onsite model, guiding the development team with Technical solutions
• Accustomed to working in a fast paced time-frame goal oriented environment and able to deliver under pressure and time constraints.

Educational Qualification:

• Bachelors of Technology in Computer Science from DA-IICT (Dhirubhai Ambani Institute of Information and Communication Technology), Gandhinagar, INDIA

Technical Skills:

Languages: SQL, PL/SQL, C, C++ Databases:MS SQL Server 2000, 2005, 2008 R2, Oracle 8.x/9.x/10.x Operating Systems:Windows (98/NT/XP/Vista/7), UNIX, Windows 2003 server Reporting Tools:Business Objects (BOBJ) XI R2/R3.1, Crystal Reports XI, Crystal Reports 2008, Web Intelligence, Infoview, CMC, Business Objects Explorer and Xcelsius Semantic Layer:Business Objects (BOBJ) Universe Designer BOXIR2/R3.1, Business Objects Information Delivery tool (IDT 4.0) OLAP:SQL Server OLAP, SSAS2000, SSAS2005 ETL:Data Stage Server Edition IBM 7.5/8.5, SQL Data Transformation services (DTS)

Professional Experience:

Confidential, Houston, TX Mar 12 - till dateOnsite Technical Lead/Data Analyst/Senior DeveloperMigration of Business Objects XI R 3.1 Universes to Business Objects 4.0:The project involves migrating the Universes in Business Objects XI R 3.1 environment to Business Objects 4.0. Focus is to migrate the universes into the new environment and then rewrite the universes wherever necessary using the Information Design tool (IDT 4.0).Responsibilities:

• Move the XI3 CMS content to the new BI4 CMS repository using Upgrade Manager tool.
• Convert the UNV file to UNX using Information Design tool.
• Wherever required, merge the multiple universes to have a common Data Connection layer and different Data Foundation layers.
• Resolve the loops by creating different contexts and perform the integrity check. Mark the families so as to distinguish the different contexts.
• Create new Business layers depending on the requirement specific to a subject area. A business layer can contain portions of Data foundation layer.
• Create the common LOV’s and Prompts in the Data Foundation so as to reuse them in the Business layers.
• Create Optional prompts wherever necessary (new feature in IDT 4.0)
• Use @Aggregate awareness and Index awareness in the new universes.
• Test the Universe by building sample queries from all the contexts and against the Web Intelligence reports.
• Document the challenges/issues faced and the resolutions for future use.

Environment: 
Business Objects (BOBJ) XI R3.1, Business Objects (BOBJ) XI 4.0, MS SQL Server 2008, BOBJ Upgrade Manager, Business Objects Information Design tool, BO Universe Designer 4.0

Confidential, Houston, TX Jul11 - Feb12 Onsite Technical Lead/Data Analyst/Senior DeveloperSCI Dashboard Project:
The project involves creating new dashboard reports for SCI using xcelsius. The webi reports are created as source data for xcelsius reports. The crystal reports are created to give additional functionality on the dashboard reports. More than 1,300 individual measures, 1,100 metrics, 42 individual data warehouse load processes, and 41 individual reports were used to develop the new dashboardsResponsibilities:

• Involved in the requirements gathering and Business logics from Business Users and prepared Business Requirements Document (BRD) and technical documents.
• Designed the dashboard database in de-normalized way for better performance of the xcelsius reports.
• Designed the logical Data Model using Visio.
• Created/Reviewed Data Stage ETL jobs to load all the dashboard metrics/KPIs.
• Create database views to derive few of the measures and KPIs.
• Created Dashboard universe using BOBJ Universe Designer to support 41 webi reports.
• Designed and created new WebI reports using Business Objects XI/R2 as per changing user requirements to feed the Xcelsius dashboard.
• Exclusively Used QAAWS, Live Office, XML mappings as per the Dash board requirements.
• Did QAAWS Sizing on the servers to perform the queries run fast and display the dash boards.
• Linked different WebI Reports from dashboard to Infoview.
• Developed various Charts and Graphs like Bar Chart, Pie Charts, and Line graphs scatteredchart.
• Used Web Intelligence for web based query and reporting.
• Exported reports into various formats like PDF, HTML, and EXCEL by using WebI Reports.
• The reports are generated on ad-hoc basis and also periodically on monthly, quarterly and annual basis.
• Involved in every phase of validation, testing and coordination with the business users.
• Interacted with the users to analyze the changes for improvement they need in initial requirements and to include those changes.

Environment: 
Business Objects (BOBJ) XI R3.1 Enterprise, XCELSIUS 2008, QAAWS, WEBI, Crystal Reports 2008, BOBJ Universe Designer, SQL Server 2008 R2, Microsoft Visio, Data Stage 8.5

Confidential, Houston, TX Aug10 - Jun11 Onsite Technical Lead/Data Analyst/Senior DeveloperSCI Trust Reports:
The project involves creating new Crystal reports and Web Intelligence reports against the SCI trust data mart.Responsibilities:

• Involved in requirement gathering from Business users, Responsible for understanding end user requirement and convert into functional requirement and involved in preparing project plan.
• Worked on the Proof of Concept for the new reports and submitted the challenges.
• Worked with the design team to create new report designs as per changing user requirements.
• Worked on the technical specification documents for the new crystal reports and web intelligence reports.
• Worked on the universe requirements documents which specify the required fields on the reports. Developed the Trust Universe on top of the Trust data. Resolved the loops, traps and createdmultiple contexts.
• Applying Row level, Report level & Object level security in the universe to make the sensitive data secure.
• Developed crystal reports and web intelligence reports as per the requirements. Created sub reports as required. Extensively used Calculations, Variables, Breaks, Sorting, Drill down, Sliceand Dice, Alerts for creating Business Objects reports.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Created complex reports using multiple queries and involved in tuning the reports in order to improve the performance of the reports.
• Developed the reports with consistent drill-down functionality including Drilldown Reports, Summary Reports and Detail Reports.
• Developed Manual Running Totals and used Complex Formulae in the reports.
• Created variables and defined formulae to capture user responses to a prompt and to display document information for WebI reports.
• Created Folders and categories in Infoview to logically differentiate BO content.
• Worked on CMC (Central Management Console) to perform Administrative tasks like Setting up user profiles, assigning rights and privileges for groups, setting up categories, and maintain BO servers
• Trained the users in viewing/scheduling the Trust reports using the Info view.
• Testing and validation of the data on backend and on Info view reports and collecting the testing evidence.

Environment: 
Business Objects (BOBJ) XI R3.1 Enterprise, WEBI, Crystal Reports 2008, BOBJ Universe Designer, SQL Server 2008 R2

Confidential, Houston, TX Nov09 - Jul10 Onsite Technical Lead/Data Architect/Senior DeveloperSCI Master Data Management
The project involves creating master data database which will be the centralized data source for all financial and sales Information across the organization.Responsibilities:

• Identified the master dimension tables used across the SCI Data Warehouse and gathered requirements for the master data tables.
• Created the source to target mapping for the dimension tables created in master database, the centralized repository for all the dimension tables.
• Created server and sequential ETL jobs to load the master dimension tables in the master database.
• Created Batch jobs to trigger the master data ETL jobs in the sequence. Identified the dependencies and designed the flow of the jobs accordingly.
• Modified the existing Data Mart ETL load process so as to source the dimension tables from the master dimension tables.
• Involved in testing and validation of the data. Collected the test evidences with validation statistics to show the total checksum & total record count in the dimension tables.
• Validated the data on the Info view reports so that the data remains the same before and after the changes and collected the report test evidences.
• Coordinate work between team members in an offshore-onsite model to achieving outstanding results.
• Defined process within the development team and review the deliverables of the team members to ensure quality deliverables.

Environment: 
Data Stage 8.5, SQL Server 2008 R2, Oracle 9.x, Microsoft Visio

Confidential, Houston, TX Mar09 - Oct09 Onsite Technical Lead/Senior DeveloperMigration of Business Objects XI R2 to Business Objects XI R 3.1
This Project primarily involves the migration of Business Objects XI R2 to Business Objects XI R 3.1Responsibilities:

• Involved in Migration of Business Objects Universes, Crystal Reports and Web Intelligence reports.
• Involved in Content Migration and Repository Migration from BO XI R2 to R 3.1
• Involved in implementing Custom Access Level, a new feature in BO XI 3.1.
• Import the folders and objects, corporate categories using Import Wizard and Incremental Import options.
• Import the BO Universes using Import Wizard and Incremental Import options.
• Unit test the universes, Crystal reports and Web Intelligence reports after the migration so as to make sure that nothing is broken in the new environment.
• Modify the Crystal reports to add the new features in X1 R 3.1. Modify the reports to use the dynamic sorting and Parameter panel options.
• Involved in data validations before and after the migration. Collected the test evidences to show that the data is not impacted after the upgrade.
• Integration testing and Regression testing of the universes and crystal, webi reports.
• Coordinated work between team members in an offshore-onsite model.

Environment: 
Business Objects (BOBJ) XI R3.1, Business Objects (BOBJ) XI R2, SQL Server 2005/2008, Oracle 8.x/9.x

Confidential, Houston, TX Aug08 - Feb09 Onsite Technical Lead/Data Analyst/DeveloperDevelopment of SSAS 2005 cubes
This project involves rewriting of SSAS 2000 cubes to SSAS 2005 from scratch to avoid virtual cubes and to improve performance. Built cubes for General Ledger and Sales dataResponsibilities:

• Involved in requirements gathering from Business Users.
• Involved in designing dimensional modeling. Designed Data Model using Visio.
• Involved in creating OLAP cubes from scratch. Designed and developed Star and Snow Flake Schema.
• Build perspectives to provide focused, business-specific or application-specific viewpoints.
• Played key role in bringing down the processing time of one of the existing cubes from 16 hrs to 10 minutes working with Microsoft consultants
• Improved the performance by creating the partitions at the database level and at the cube level, aggregations based on user defined queries, rewriting the MDX queries based on the cold cacheand warm cache statistics provided in MDX studio
• Involved in defining attribute relationships, removing parent-child relationships which might cause poor performance of OLAP cube queries.
• Captured the user queries on the cube from SQL profiler and changing the cube for creating aggregations based on the user defined queries.
• Converted parent-child dimensions to regular dimensions using Analysis Services Parent-Child Dimension Naturalizer for better performance of OLAP Queries.
• Trained the power users to use the OLAP cubes using Microsoft Excel pivot tables.

Environment: 
SQL Server Analysis Services 2000/2005, MDX Studio, PCDimNaturalizer, Microsoft Visio

Confidentialnational, Houston, TX Aug07 - Jul08 Onsite Technical Lead/Data Analyst/Senior DeveloperCreate new Accounts Payable Data mart/ETL jobs/Reports
This Project primarily deals with creating new Data mart to store Accounts Payable dataResponsibilities:

• Main responsibility is to gather the requirements from the Business users and creating requirements document.
• Involved in data modeling and created the star schema data model with the fact and dimension tables.
• Created design documents and created data mapping documents between source and target tables.
• Involved in creating High level design and Detailed Design documents.
• Involved in coding and reviewing the ETL jobs using Data Stage 8.5 to pull the data from the source, cleanse the data, and transform the data as per the business rules and load the AP data mart.
• Involved in Data load from multiple sources (Flat file, Oracle database, SQL databases) and validating data.
• Worked on Data clean-up and performance related issues while data preparation.
• Worked on the technical specification documents for BO Universes and Crystal/Webi reports.
• Created BO Universes on top of the new data mart which acts as semantic layer between underlying database and the reports.
• Involved in development of crystal reports and adhoc webi reports driven from AP Data mart.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Created test cases based on requirements and mapping for ETL and Reports and tested the data, universe and reports as per the test cases.
• Mentored the team members and coordinated with offshore team for ETL coding and reviewing the work delivered.
• Reviewing the standards, communicating with Business users for any issues or clarifications on requirements and responsible for the smooth delivery of the project (end to end from requirements gathering to delivering crystal reports and adhoc reports).

Environment: 
Business Objects (BOBJ) XI R2, Crystal Enterprise, Web Intelligence, Data Stage 8.5, SQL Server 2005, Oracle 9.x, Microsoft Visio, Erwin

Confidential, Houston, TX Jan07 - Jul07 Data Analyst/Senior DeveloperCreate new Financial Data Warehouse/ETL jobs
This Project primarily is to create a new data warehouse which has all of the data that will support the accounting team. The data will be sourced primarily from Lawson (third party tool)Responsibilities:

• Identified all the financial data related components to be migrated from the existing databases to the new Financial Data warehouse.
• Gathered and analyzed the requirements from the Business users for new data. Analyzed the data in the Lawson system and understating the data. Created requirements document
• Single point contact for all technology teams for all business requirements
• Involved in physical and logical data modeling and created high level and detail design documents.
• Created indexes and constraints for better performance and maintainability of the database.
• Created process overview documents for every database table with the meta data of the table and load process
• Created source to target mapping documents for all components. Extracted, transformed, cleansed and loaded financial data through Data stage ETL jobs from Flat files, Oracle database to SQL database.
• Involved in peer reviews of the ETL jobs.
• Created Re-conciliation jobs to automate data validation and to ensure correct data.
• Created DME queries against Lawson source system for data validation.
• Facilitated work allocation to team members, provided day-to-day technical direction, and managed deliverables to define target dates and assure quality
• Implemented processes within the team to ensure quality deliverables.
• Reviewing the standards, communicating with Business users for any issues or clarifications on requirements. Worked as a team member and independently.

Environment: 
Data Stage 7.5/8.5, SQL Server 2005, Oracle 8.x, Microsoft Visio, Erwin

Confidential, Houston, TX Apr06 - Dec06 Data Analyst/Senior DeveloperMigration/Development of ETL jobs for SQL Upgrade
This Project primarily involves with the testing of existing ETL jobs, creating new ETL jobs to eliminate DTS packages, test existing Info view reports and universes for upgrading databases from SQL 2000 to SQL 2005.Responsibilities:

• Involved in Creating ETL Design documents as per the existing DTS packages logic.
• Involved in creating new ETL jobs for all the DTS packages.
• Involved in creating Reconciliation jobs to validate data against the source tables.
• Created Unit Test plans, Integration Test Plans and Acceptance Test Plans for the testing of the ETL jobs and BO reports against the new environment in SQL Server 2005
• Involved in testing of existing crystal reports, web intelligence reports
• Modified and tested the BO Universes.
• Involved in providing the estimates and project management activities.
• Mentored the team members and managed customer expectations by clearly documenting and maintaining project deliverables, plans and status throughout the project.
• Submitted Book of Knowledge on findings in the project and steps to be followed while upgrading from SQL 2000 to SQL 2005 which will be helpful for other projects across the organization.

Environment: 
Data Stage 7.5/8.5, SQL Server 2000, SQL Server 2005, Business Objects (BOBJ) XI R2

Confidential, Houston, TX Dec04 - Mar06 Data Analyst/Developer/Defect Prevention Anchor/Configuration ControllerMaintenance and Enhancement of SCI DW projectThis Project deals primarily with development and maintenance of SCI Data Warehouse which involves making sure the data present in DW is in sync with the OLTP systems, periodically refreshing the Data in DW through incremental load of data from OLTP systems and providing users with reports for analysis purposes. The population of data in DW is typically done through Data Stage jobs. The tasks that are involved are gathering requirements from users, creating design documents, creating new ETL jobs as per the business requirements, modifying the existing ETL jobs for any changes in business requirements, developing OLAP cubes and providing users with Crystal Reports, excel reports sourced from cubes which will help them in better viewing and analyzing the data.Responsibilities:

• Involved in the Requirements analysis and Technical Specification Documentation.
• Schedule transfer of data from real time database to data warehouse and databases. Created High level design documents and Detailed Design documents.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.Developed Star and Snow Flake Schema as a data analyst.
• Involved in extracting, transformation and loading processes from various sources like OLTP systems, Legacy and Flat files. Created DTS packages to copy tables, schemas and views and to extract data from Excel and for migrating data for one server to another.
• Created stored procedures, tables or views or even from command queries.
• Created components, tools, techniques, methods and procedures used in an On-Line Analytical Processing (OLAP) environment for accessing and translated data into understandable and usable business information using SSAS 2000.
• Maintained production OLAP cubes, wrote MDX queries to generate customized reports for users in Excel 2003/2007.
• Performed daily validations using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) table and monitoring using Performance Dashboard.
• Performed tuning to optimize SQL queries using SQL profiler and query analyzer. Creating Partitioned views, implemented partitioning at the database table level.
• Responsible for Production support and the DW nightly ETL load process.
• Involved in implementation of modules from requirements sign-off through development, QA and user acceptance testing to production.

Process / Quality Aspects:
Worked as the Configuration Controller (CC) and Defect Prevention AnchorResponsibilities as CC:

• Implementation of Infosys Processes and standards in software development. Responsible for Configuration Management audit and Release audit. Responsible for configuration identification (Product Versioning) and accounting of all data associated with a software product.
• Ensuring backups and archival of project documents. Responsible for providing role based access to team members for project documents.

Responsibilities as DP Anchor:

• Generated reports on defects identified every month. Identified the root cause analysis of the defects using fish-bone diagram. Reviewed the standards and updated the checklists based on the identified reasons.
• Implemented action plan by conducting knowledge sharing sessions and changing the process for minimizing the defects.

Environment: 
Data Stage 7.5 ETL tool, SQL Server, Oracle, Visio, Business Objects XI R2, Crystal Enterprise, SQL Profiler, SSAS 2000