SUMMARY

• 8+ 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, XI R2 and XI 3.1, Crystal Enterprise 2008, Business Objects Universe Design
• Expert in writing T-SQL, Data Stage ETL Tool, Data Cleansing, Data Scrubbing and Data Migration.
• Transformed data from one server to other servers using Data Stage tool like Bulk Copy Program (BCP), Data Transformation Services (DTS) and Data Stage ETL tool.
• Created Web Intelligence, crystal reports using Business Objects
• Experience in Migration of Business Objects XI R2 to XI 3.1 on clustered environment.
• Certified in SAP Business Objects Advanced Universe Design
• Knowledge on
• Experience in OLAP, ODS, Snowflake schema, Star schema, ETL, MDX, DBMS and Data Modeling.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP, Data Replication and DTS Packages.
• Certified Training on SQL Server Analysis Services 2005
• Attended sessions to learn new features in SSAS ed by Microsoft Consultants
• Worked with Microsoft Consultants on performance improvement of SSAS 2005 cubes
• Expertise in ETL tools like Data Stage Server Edition, Data Transformation Services (DTS), Bulk Insert which brings data from variety of sources (SQL database, Access database, Flat files, oracle databases) to load data into Data Warehouse and Data Marts environment
• Expert in creating complex crystal reports with 5+ sub-reports, crosstabs, drill downs and more than 10 grouping sections, webi reports from universes and excel reports sourced from SSAS cubes.
• Expertise in creating SSAS 2000/ 2005 OLAP cubes
• Expertise in Data Modeling using Visio for creating new Data Marts
• Experience with adhoc reporting, Parameterized, Custom Reporting using Business objects for daily reports and SSAS projects
• 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 building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server.
• Expertise in generating reports using Business Objects XI R2/R3, Crystal Reports
• Familiar with Fragmentation and Query analyzer for SQL Server 2000/2005 and 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 planning, Integration 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.
• Accustomed to working in a fast paced time-frame goal oriented environment and able to deliver under pressure and time constraints

TECHNICAL SKILLS

• Data Stage Server Edition ETL Tool
• BO XI R2/ BO XI 3.1 Enterprise Edition
• Crystal XI R2 and 2008 Reporting Tool
• WebI reports
• Business Objects Universe Designer.
• SSAS OLAP cubes SQL data transformation services (DTS).
• Database (SQL Server 2000/2005/2008 )
• Sybase 12.5/15.
• Data Modeling tools (Visio)
• Performance Dashboard
• MDX studio
• Activity Viewer
• Windows 2003 server
• Windows XP
• MS-DOS
• UNIX.
• Data modeling & SQL Server Support tools like Visio

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Lead/Developer/Data Analyst

Responsibilities:

• Involved in requirements gathering from Business Users
• Designing the database for Pivot reports
• Creating Universes and Web Intelligence reports for the Middle office users.
• Converting Desktop Intelligence reports to Web Intelligence reports.
• Setting up users the security on the BO environment and maintenance activities like restarting servers, checking the event logs, scheduling and publishing reports.
• Creating stored procedures and views as per the business requirements.
• Involved in every phase of validation and testing and coordinating with the users
• Interacted with the users to analyze the changes for improvement they need in initial requirements and to include those changes
• Sybase 15 and SQL server 2005 was the back end databases.

Environment: Tools: Business Objects XI 3.1 Database: Sybase 15, Sql server 2005, Oracle 11g OS: Windows 2003 Server, UNIX

Confidential

Lead/Developer/Data Analyst

Responsibilities:

• Involved in requirements gathering from Business Users
• Designing the database in de-normalized way for better performance of the xcelsius reports
• Designed Data Model using Visio
• Created/Reviewed ETL jobs to load all the dashboard metrics/KPIs
• Create views to get few of the measures and KPIs
• Created Dashboard universe to support 41 webi reports
• Involved in every phase of validation and testing and coordinating with the users
• Interacted with the users to analyze the changes for improvement they need in initial requirements and to include those changes
• SQL server 2005 was the back end database used

Environment: Tools: BO Universe Designer, WebI, crystal reports designer, Sql server 2005 Management Studio, Visio, DataStage Database: SqlServer 2005. OS: Windows 2003 Server

Confidential

Developer

Responsibilities:

• Identifying the master dimension tables used across the organization
• Gathering requirements for the master data tables
• Create to source to target mapping for the dimension tables created in master database.
• Create ETL jobs to load the tables in the master database
• Identify the components using the same data but sourced from different systems
• Making changes to the existing ETL jobs, stored procedures, views to be sourced from the master database
• Testing and validation of the data on backend and on infoport reports and collecting the testing evidence.

Environment: Tools: Sql server 2005 Management Studio, DataStage 7.5.1

Confidential

Developer

Responsibilities:

• Identifying all the components to be migrated from the existing databases.
• Gathering and analyzing the requirements from the Business users for new data
• Creating requirements document, data modeling, creating design documents
• Create process overview and source to target mapping documents for all components
• Creating High level design and Detailed Design documents.
• Extracted, transformed, cleansed, and loaded financial data through Datastage ETL jobs from Flat files, oracle database to SQL database
• Created Re-conciliation jobs to automate data validation and correction
• Create new tables, views, indexes and constraints for performance and better maintainability of the database
• Created DME queries for data validation
• Responsibilities include mentoring the team members, coordinating with offshore team for ETL coding and reviewing those jobs reviewing the standards, communicating with Business users for any issues or clarifications on requirements
• Responsible for the smooth delivery of the project
• Worked as a team member and independently

Environment: Tools: DataStage 7.5 ETL tool, Visio

Confidential

Developer

Responsibilities:

• Involved in the requirements analysis and Technical Specification Documentation.
• Designed data models using Visio. Involved in data modeling of four Data marts.
• Designed Fact tables, Dimension tables, scheduled transfer data from real time database to data warehouse and databases.
• Creating High level design documents, 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
• Designed and 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.
• Creating crystal reports sourced from universes, stored procedures, tables or views or even from command queries.
• Creating complex crystal reports linking multiple data connection strings in the same report.
• Created standard Reports and Cross Tab Reports and Drill Through reports in crystal reports.
• Designed universes that acts as a semantic layer in Business Objects
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS 2000/2005
• Maintained production OLAP cubes, wrote MDX queries to generate customized reports for users in Excel 2003/2007.
• Performed daily using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Creating WebI reports and adhoc reports from Business Objects Universe
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) table and monitoring using Performance Dashboard
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Performed tuning to optimize SQL queries using SQL profiler and query analyzer.
• Creating Partitioned views, implemented partitioning at the database table level.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using Business objects
• Giving estimates for various tasks and Project Management
• Involved in implementation of modules from requirements' sign-off through development, QA and user acceptance testing, to production
• Process / Quality Aspects: Was the Configuration Controller (CC) and Defect Prevention Anchor for the project
• Implementation of Infosys Procedures 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 archive for project documents.
• Responsible for providing role based access to team members for project documents
• Generating reports on defects identified every month.
• Identifying the root cause analysis of the defects using fish-bone diagram.
• Reviewing the standards and updating the checklists based on the identified reasons
• Implementing action plan like conducting knowledge sharing sessions and changing the process for minimizing the defects

Environment: Tools: DataStage 7.5 ETL tool, SQL Server Analysis Services, Visio, Business Objects XI R2/R3, Crystal Enterprise, Performance Dashboard

Confidential

Developer

Responsibilities:

• 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 performance tuning of the OLAP Cubes
• 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.
• The performance improvement achieved is the result of creating partitions at the database level and at the cube level, aggregations based on user defined queries, rewriting the MDX queries based on the cold cache and warm cache statistics provided in MDX studio, defining attribute relationships, removing parent-child relationships that can 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.

Environment: Tools: SQL Server Analysis Services, MDX Studio, Activity Viewer, PCDimNaturalizer

Confidential

Developer

Responsibilities:

• Main responsibility gathering requirements from the Business users
• Creating requirements document, data modeling, creating design documents
• 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
• 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 creating universes on top of these tables which acts as semantic layer between underlying tables and the reports
• Involved in development of crystal reports with cascading prompts and adhoc reports driven from AP Data mart
• Responsibilities include mentoring the team members, co-coordinating with offshore team for ETL coding and reviewing those jobs reviewing the standards, communicating with Business users for any issues or clarifications on requirements
• Responsible for the smooth delivery of the project (end to end from requirements gathering to delivering crystal reports and adhoc reports)

Environment: Tools: DataStage 7.5 ETL tool, Visio, Business Objects XI R2/R3, Crystal Enterprise.

Confidential

Developer

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
• Involved in testing of crystal reports and modifying the universes
• Involved in providing the estimates and project management activities.
• Mentoring the team members
• Manage customer expectations by clearly documenting and maintaining project deliverables, plans, and status throughout life of the project
• Submitted Book of Knowledge on our 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: Tools: DataStage 7.5 ETL tool