SUMMARY

• 4 Years of IT experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of SDLC.
• Worked on SSIS improvements for the MCF system to accommodate the Facets files.
• Migration of DTS - SSIS packages.
• Worked on writing VB.net code in SSIS components like script task and script component.
• Used script task for calling VB.net methods using VB.net script.
• Used MicroStrategy Agent (Templates, Filters, and Metrics) to generate advanced reports in grid, graph, and SQL mode, consisting of data analysis by combining a template wif filters.
• Hands on experience in creating database objects such as Tables, Constraints, Indexes, Views, Indexed Views, Stored Procedures, Triggers and Cursors using T-SQL and PL/SQL
• Expertise in Client-Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQLPLUS, TOADandSQL LOADER.
• Strong Experience in designing cubes, defining referenced relationships, calculated members, writing MDX queries and in identifying KPI’s in SSAS 2008/2005.
• Good experience in Query Optimization and Performance Tuning.
• Experience inOracle supplied packages, Dynamic SQL, RecordsandPL/SQL Tables.
• Managed reports in SSRS via Management Studio and also Report Manager by setting up permissions and RDL files.
• Used SSRS to Ad-hoc, Cross-Tab, Drill-down and Sub-Report, customized Reports, on-demand reports and involved in analyzing multi-dimensional reports in SSRS.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Experienced in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.
• Skilled in SQL 2005 Business Intelligence tools, ETL processes & strategies using SQL server Analysis and Integration Services.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Extensive noledge of Installation, Configuration and Maintenance of SQL Server/BI Suite (2005/2008), usage of SQLCMD utilities, Creation and Management of Logins, Users, Schemas and Permissions, Transaction Logs, DBCC commands, Automation of SQL Server using Operators, Jobs and Alerts, Database Backups, Restoration and Recovery, High availability of Database using Clustering, Standby Servers, Log Shipping and Database Mirroring and Replication and Bulk Copy (BCP).
• Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform it, mart it to data warehouse and provide proper error handling and alerting.
• Extensive noledge of Relational Database Management Systems using Complex Stored Procedures and Triggers.
• Developed some PL/SQL scripts, which will change the server data across all the components in the system
• Experienced in implementing Data Warehouses using SQL 2008/2005 Analysis Services creating Cubes and populating them wif Dimensions and Facts.
• Upgrade DTS packages to SQL Server Integration Services (SSIS) and Expertise in Data Transformation Services (DTS) in SQL server 2000.
• Migration of MS SQL SERVER 2005 to MS SQL SERVER 2008.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/2005/2008 R2, DB2, IDMS.

Programming Languages: T-SQL, PL/SQL, C#, VB 7.0, 7.1, 8.0, 9.0, 10, ASP.Net, Oracle 9i, 10g and UNIX Shell Script, Perl Script.

Tools: & Packages: SQL Server Management studio, Facets 4.81, Enterprise Manager, Profiler, Business Intelligence Development studio (BIDS), DTS, ETL, DTSxChange, Visual Source Safe(VSS)6.0, Business Objects XIR2/XIR1/6.X/5.X, Informatica, Visual Studio .NET.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), MicroStrategy 8.1/ 8.0.2/ 7.5/ 7 me/7.x, Cognos, MS Visio, Erwin, Crystal Reports 9.0/XI.

Web Technologies: XML, XPath, HTML, XSL, JavaScript, IIS.

Data Modeling: Visio 2007 and Erwin 4.1.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

MS SQL SERVER BI Developer

Responsibilities:

• Worked closely wif the requirement team and designing team for understanding the business requirement.
• Developed SSIS packages to accommodate new business requirements.
• Used Oracle as both Source and Destination while bring data using SSIS.
• Serve as technical expert guiding choices to implement analytical and reporting solutions for client.
• Designed various SSIS modules in order to fetch the data in the data staging environment based on the different types of incoming data.
• Designed various packages using various task e.g. For Each Loop, File System Task, Fuzzy Lookups, Multicasting various others for data cleansing.
• Extensively used Views for complex joins queries involving multiple tables from different databases.
• Created complex Stored Procedures, Triggers, and Functions for validation process & for loading data from the staging are to the product database in SQL 2008.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures
• Implemented Views (Partition View, Parameterized Views) in T-SQL as well as PL/SQL code for making joins between the tables.
• Partitioned large Tables usingrange partition technique.
• Create spreadsheets and reports using oracle PL SQL, Toad and SQL
• Used TOAD For ORACLE for writing PL/SQL queries and stored procedures.
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
• Wrote scripts in Oracle SQL to monitor batch processing to get early warnings in case of wrong data processing.
• Worked closely wif DBA's deploying packages for staging/production server.
• Communicated wif the team members on regular basis.
• Change requests had to be made for all the implementations.
• Documented all database objects, which were used in the project and for further upgrades and maintenance.
• Createdrecords, tables for improving Query performance by reducingcontext switching.
• Measured the existing size of the data on the relational side, plan for growth (addition of new data everyday) for a year.
• Designed and applied Entity and Attributes description and definition for the models.
• Implemented different types of Constraints on tables designed in the data staging area for the migration.

Confidential, Detroit, MI

MS SQL SERVER DBA/SSRS/SSIS Developer

Responsibilities:

• Created Complex SQL queries, Derived tables, common table expressions (CTEs), complex stored procedures, views, indexed / materialized views, generating Cross Tab Tables (Pivot), full text Search, Distributed Queries, user defined functions (UDF), Cursors and Database triggers. Extensively involved in designing (Logical and Physical) of customer database.
• Migration of DTS - SSIS packages.
• Installed and configured Oracle 10g.
• Designed Data Modeling, Design Specifications and to analyzedependencies.
• Created Tables, Views, Constrains, Synonyms, and Sequences using PL/SQL.
• DTSxChange tool to profile, convert & Monitor DTS and SSIS packages.
• Designed data flow & control flow tasks which were unsuccessfully converted by DTSxChange.
• Performed Unit testing of the converted packages.
• Worked on writing VB.net code in SSIS components like script task and script component.
• Used script task for calling VB.net methods using VB.net script.
• Handled row level errors using script component transformer using VB.net methods.
• Produced Ad-Hoc reports for testing purposes.
• Supported specific user groups wif reports based on necessary business requirements.
• Used Pull delivery to allow employees to grab any of the reports they need and in whichever format they desire.
• Used to support the data processing engine in database intensive operations like query Performance tuning, parallel query algorithm by writing stored Procedures.
• Measured the existing size of the data on the relational side, plan for growth (addition of new data everyday) for a year.
• Communicated wif the team members on regular basis. The change requests had to be made for all the implementations.
• Created XML, PDF, EXCEL files using SSRS.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.

Confidential

MS SQL Server SSRS/SSIS Developer

Responsibilities:

• Worked closely wif the requirement team and designing team for understanding the business requirement.
• Configured Oracle 9i AS Portal for both Linux and Windows, for production, QA and development environments.
• Developed and implemented multiple applications and reporting tools using C#.Net and ASP.Net reducing costs and automating processes.
• Implemented different types of Constraints on tables designed in the data staging area for the migration.
• Designed various SSIS modules in order to fetch the data in the data staging environment based on the different types of incoming data.
• Created an IIS virtual directory for SQL Server 2008.
• Designed various packages using various task e.g. For Each Loop, File System Task, Fuzzy Lookups, Multicasting various others for data cleansing.
• Strong Experience in designing cubes, defining referenced relationships, calculated members, writing MDX queries and in identifying KPI’s in SSAS 2008/2005.
• Extensively used Views for complex joins queries involving multiple tables from different databases.
• Created complex Stored Procedures, Triggers, and Functions for validation process & for loading data from the staging are to the product database in SQL 2005.
• Implemented Views (Partition View, Parameterized Views) and other T-SQL code for making joins between the tables.
• Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging, Production and Data Warehouse environments.
• Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005 Reports Services (SSRS).
• UsedCrystal Reportsto track logins, mouse over’s, click-through, session durations and demographical comparisons wif SQL database of customer information.
• Integrated data from homogeneous, heterogeneous sources and legacy systems (SQL, DB2, Excel sources) to SQL server database.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Maintained scheduling the subscription reports wif the subscription report wizard.
• Utilize SSRS (Reporting Services) to generate user/business reports provide technical support to adept to Team Lead.
• Serve as technical expert guiding choices to implement analytical and reporting solutions for client.
• Documented all database objects, which were used in the project and for further upgrades and maintenance.

Confidential, San Diego, CA

MS SQL Server SSRS/SSIS/SSAS Developer

Responsibilities:

• Managed the entire process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers in sales area.
• Developed reporting templates to produce quicker SSRS solutions based off a base set of requirements.
• Proactively promoted the reporting life cycle for the creation and management of business reports.
• Created reports for auditing and testing OLAP database for data integrity or anomalies.
• Migration of MS SQL SERVER 2005 to MS SQL SERVER 2008.
• Designed reports using MDX and the reporting wizard to produce Drill Down and Drill Through reports to provide custom views of the information for users.
• Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.
• Worked wif Oracle and MS SQL Server databases to create complex reports.
• Created crystal reports, ODBC and database connections.
• Created MOLAP Warehouse on SQL 2008 Server Analysis Services and created cubes wif dimensions and facts.
• Analyzed and understood all data in the source databases and designed the overall data architecture and all the individual data marts in the data warehouse for each of the areas of Compliance Management, Preference Management, and Privacy Management.
• Involved in the creation of Tables, Table Partitions, and Indexes.
• Developed and maintained various cubes using MDX complex queries using SSAS.
• Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
• TEMPEffectively worked on Facts, Dimensions, and Cubes and wrote MDX queries using MS Analysis Services (SSAS).
• Analyzed the requirements and selected the appropriate fact tables/created fact tables.
• Designed SSAS cube to hold summary data.
• Handled alerting mechanisms, system utilization issues, performance statistics, capacity planning, integrity monitoring, population, maintenance, reorganization, security, and recovery of databases.
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created application-specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
• Worked on database connections, SQL joins, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Confidential

MS SQL Server Developer/SSRS Developer

Responsibilities:

• Revision/update of MicroStrategy reports that change as a result of Engineering release related changes to the data warehouse structure and functionality.
• Installed MicroStrategy 8.0.1 and upgraded it to the latest 8.0.2 version.
• Used MicroStrategy Agent (Templates, Filters, and Metrics) to generate advanced reports in grid, graph, and SQL mode, consisting of data analysis by combining a template wif filters.
• Designed and developed ER diagrams (Physical and Logical using MS Visio) and mapping the data into database objects.
• Developed stored procedures, views and functions.
• Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Created complex expressions, calculations, sorting, filtering to enhance data presentation in reports.
• Created insert, update and delete triggers on some tables in order to capture any DML activities happening on some crucial and confidential data.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, joins, triggers, cursors, UDFs for SSRS.
• Created and maintained databases, tables, users, logins, indexes, check constraints, and business rules using T-SQL.
• In order to perform Error Handling created each stored procedure wif TRY and CATCH blocks.
• To get the best performance for SSRS reports and applied performance tuning on various SQL procedures and created proper indexes on tables.
• Involved in activities of Integration testing and deployment in various environments, like QA, staging and production.
• Involved in various activities of generating Insert and update scripts to load the data to and from production servers to dev servers.
• Designed and developer SSRS security architecture using Role based security model provided in SSRS 2005.