SUMMARY:

• Overall 12+ years of hands - on experience in Complete SDLC including Designing/Modelling, hands on development, Performance Tuning, Enhancing, and Testing SQL, NoSQL, OLAP/cubes, OLTP, ODS, ETL, Report systems and web applications.
• Drawing upon experience with clients in Healthcare, finance, media, education and manufacturing domains, have built a strong experience for Analysis, design, and problem resolution.
• With most clients having large globally spread Teams, have good understanding in resource utilization and good team communication.

TECHNICAL SKILLS:

Database: MongoDB 3.2.9(NoSQL), PostgreSQL 9.4 (PL/pgSQL), SQL Server 2014/2012/2008 R 2/2005/2000/7.0 , SSIS (SQL Server integration services), SSRS (SQL Server reporting Services), UDF (User defined functions), SSAS (SQL Server Analysis Services). DTS, Oracle PL/SQL 8i/9i/10g/11i, Disaster recovery plan via Log Shipping, Profiler, Stored Procedures, Views, Jobs, Data Modeling, Data Warehouse, Triggers, Scroll Cursors, SQL Server Replication, DBCC commands for core database/system related operations/tasks, multi-dimensional model databases, SSAS, DataMart, Star, snowflake schemas, Excel with advance VBA for ad-hoc reporting. Expertise in Shell scripting (UNIX/AIX/Solaris environment) as well as VBScripts, PowerShell.v4.x

Software Development Java/J2EE, Spring 4.x, TDD, C#, VB.NET, ASP.NET, WCF, jQuery, JSON, ADO.NET, ADO, Hyperion Interactive Reports v9.2/9.3, Hyperion Brio v8.3, Visual Basic, VBScript, ASP, JavaScript, HTML, XHTML, DHTML, AJAX, T-SQL, CSS.

Server Products Docker, MongoDB Ops Manager, PEM (PostgreSQL Enterprise Manager), Idera, IIS 5.0/6.0/7.0, Windows 2000/2003/2008/2008 Server R2/2012 Data Center, VMware ESXi 5.5

Other Tools Database design / ER Modeling using ERWIN 9.5, dB Schema,, Embarcadero Data Architect 10.0 , Toad for PostgreSQL ,Red Gate ,Enterprise Architect, 4+1 views and design using UML with Visio, Configuration management using Visual SourceSafe, GIT, TFS (Team foundation System) and CVS/SVN, Application defect tracking with Mercury-Test Director, Bugzilla

PROFESSIONAL EXPERIENCE:

Confidential, Dallas,TX

Senior Consultant/Architect/DBA

Responsibilities:

• From ground-up built 7 servers for non-prod, and 1 prod environment (replica set) for MongoDB 3.2.9 Server for their c3 - survey application. Also configured the servers for Ops Manager based monitoring, and new relic based monitoring to co-relate the application/database monitoring.
• Setup Docker based MongoDB sandboxes for Development team and QA team. This was done to manage the test data that is dear to developers and QA, but for combined testing utilized the common Integration server for housing the same (docker image based environment).
• From ground-up built 7 servers for Non-Prod and 1 production environment with streaming replication to a reporting instance (plain single server) for PostgreSQL 9.4 with PITR backups for c3 admin/customer application.
• Configured PEM PostgreSQL enterprise manager for each of the environments.
• Setup monitoring for day to day administration including log monitoring, deadlock scenarios, performance issues pertaining to memory, application and user specific loads.
• Setup alerts for certain thresholds, for example memory utilization, CPU utilization etc.
• Setup streaming replication for the reporting database. This was utilized to generate feeds for CDS application.
• Worked extensively on MongoDB Scripts in JavaScript for document analysis, schema changes for existing documents within the collection, and ad-hoc reporting on top of all the collections.
• Worked on performance tuning for new development work done on MEAN Stack. I contributed to the MongoDB queries. This involved capturing the queries in logs, looking at their execution plans, identifying areas wherein locks can be avoided. Also identifying non-performing queries and indexes.
• Worked on performance tuning, and blocking issues in ACT Application on SQL Server 2012. These were resolved using statistics/details captured from IDERA.
• Worked on PostgreSQL based database implementation to tweak queries for better performance. In these heavily utilized the PEM to profile and capture the slow queries.
• Worked on micro-Service architecture proposed by the EA team for application. This required similar micro-DB architecture as well. Designed, and developed physical and logical data models using ERWIN and managed in Mart for versioning. Also generated relevant Data Dictionary, and reports for visualization so that consensus with application development team can be built.
• Worked on Templates to version Database objects, earlier the model was based on release.
• Created framework and process for automated deployment of Database changes (Universal for the SQL Server, MongoDB, and PostgreSQL) to any target environment. This script was written in PowerShell and integrated with Jenkins.
• Created process in place, to compare and capture differences between Production and non-production environments. Additionally this process compared the data definition of similar named fields and highlighted any inconsistency.
• Evaluated Toad Data Modelling tool, to reverse engineer PostgreSQL based database for c3 (Customer configuration center) application.
• Built automated scripts in shell to automate deployment, Import database backup, and initialize the PostgreSQL 9.4 server. This script was utilized to build 7 environments (DEV, QA, Regression, PLAB, UAT, Pre-PROD, and PROD). Created baseline code based for this PostgreSQL DB Scripts using PL/pgSQL.
• Defined Security structure for the access to PostgreSQL DB (Read-only, Read Write, Application Access).
• Created cron jobs for DB maintenance tasks including, backup, restore, Alerts, log rotation, etc.
• Worked on configurations to fine tune DEV box, so that we could capture detailed logs.
• Worked on dB Schema Data Modelling tool, to reverse engineer the new application Survey-Design, and Survey-Consumer
• Built automated scripts in shell to automate database backup, and initialize the MongoDB 3.2 server log rotation etc. This script utilized as a cron job on a NAS connected server.
• Created python script as a POC for connecting to Mongo DB, and verify load test on the end point to verify DB performance for 10/20/50 user load. A similar solution created using a custom jmeter script was not suitable for this approach, as it needed too much of work.
• Created baseline code based for this MongoDB Scripts using JavaScript/NoSQL. These Scripts were used to enforce standards for the keys in a document, Collection Names.
• Created Automated Script (in Shell) for automated deployment of DB Changes to any environment.
• Created Security profile for the access to DB (Read-only, Read Write, Application Access).
• Configured and managed the replica-Set for the mongo DB for performance, and disaster recovery.
• Installed, Configured and tweaked Ops Manager for managing MongoDB instance.

Confidential, Orlando, Florida

Senior Consultant/Architect

• Conducted extensive interview sessions with Product Configuration system’s (analysts and their technical team), ecommerce (analysts and technical team), GSA System’s team, EZtIcket’ team (Analysts and technical team), supporting the implementation for field by field business knowledge, and mapping.
• Created Logical Data Model using Embarcadero(ER Studio/Data Architect) with Star Schema (with minor snow flaking). Discussed with various stakeholders on strategy for reporting.
• Created Physical data model and generated data dictionary from the Data Model itself. This was shared with complete team including business analysts to understand the underlying data.
• Currently client is utilizing the Business Objects, and had defined many views in the BO Universe. Translated these views in the data modeling tool.
• Worked with Product Configuration System’s team and DBA to replicate the data to another server, mainly to enable CDC on this and capture any partial version of data. This was important, as a few Products in SeaWorld can change multiple times within a day with no predictable pattern. The PCS System was not capable of reporting such changes to any external system.
• Defined a DQS within the SQL Server so that we can streamline default replacement values across the board for dates, price values, etc. consistently.
• Defined the Loading Strategy, Logging and reload strategy on failures using a unified Framework within the model.
• Modeled and Developed 5 Cubes for the client based on the sales Model (for Global Reservations only).
• Worked on their Vacation Packaging project, to completely integrate this Sales Model with Trisept’s data, as SeaWorld is transitioning to use Trisept for their Vacation Packaging.
• Provided Intuitive design for many degenerate dimensions, and time dimensions to avoid reporting challenges.
• Evaluated MongoDB, and PostgreSQL for NoSQL needs for this project. This was mainly done for user activity, and ticket purchase, and possible benefits we could have compared to current system.
• Implemented 100+ Packages in SSIS/SQL Server 2012 (aligned against 2 Sales Systems, 1 Global reservation system, 1 Call Center System ,1 Point of Sale System and 1 Financial System).
• Worked on to maximize the performance of the packages, and schedule them as Jobs.
• Defined Custom C# components, used across all the SSIS packages for unified reporting of the data they process.
• Written Scripts to run on putty (SSH Client for UNIX), to Start a Job in Autosys (CA Product deployed on UNIX Platform)
• Defined the Testing framework within the model that can mark the process for failure, even if the package had finished successfully. This aided in reload/rerun for same business dates.
• Defined and managed the entire Structure in TFS for version management. This was done using Visual Studio(for SSIS Packages and Database)

Confidential, Detroit, Michigan

Senior Consultant/Architect

• Worked extensively on Bill Inmon/Ralph Kimball hybrid model implemented in this project. The EDW was partially normalized, and this is where majority of data was sourced from in the CPDM DataMart.
• Designed and implemented Data Model for 5 Lines of business, for which Data was sourced from Flat Files, Access Files, Oracle DB, and XML Files. This Model re-used many existing confirmed dimensions and fact tables, and introduced some more fact tables.
• Worked with Business stakeholders, Gathered requirements, documented data flow, and designed data model (Using Erwin) and created a POC to find terminated doctors in 3 months rolling period, and patients that had visited these doctors in past 6 months. This was used to inform the patients that their doctor was no longer covered in the BCBSM health plans/Insurance coverage. This was in order to achieve NCQA (National Committee for Quality Assurance) health guidelines. Later lead a project for this LOB providing design specifications, directions and code review of developers.
• Worked with business and Completed Extensive analysis for Claims in Enterprise data warehouse of BCBSM (Oracle 11g) using PL/SQL, to assist business in making decisions (whether to get data in CPDM or not). This was very critical and formed basis for the design of new SSIS Packages, so performance tuning of queries was amongst the top priorities. Routinely monitored the performance on both ends (on performance of Oracle queries, and SQL Server queries)
• Managed a team of 8 developers to provide deliverables for this Line of Business.
• Provided data model and implemented an SSIS Interface (in SQL Server 2012) to load 15+ GB XML Files from Portico, and used XSLT to break Complex XML Files to simpler XML Files and load them into SQL Server.
• Designed and Created a Custom log provider for SSIS Packages, that was registered in Visual Studio- BIDS that captured the log information at various steps (pre-execution, Validation, Post execution etc.) and recorded the relevant information in a log table in database.
• Designed and implemented SSIS package based(SQL 2012) Job to Load 90 GB Flat files (coming from Symmetry Engine) to load into SQL Server tables and then selectively merge data into Final table using stored procedures.
• Completed design changes and Performance tuning of 20+ stored procedures in various subject areas and Reports (aka Dashboards) written in SSRS.
• Worked on 5+ SSRS reports for the dashboards created for POs to reflect their performance and incentives for a quarter.
• Created Validation scripts for many subject areas including - “EDW - member enrollment”, Provider/Practitioner data, Professional Claims. All these scripts were created on the lines of - “Data Completion”, “Data Accuracy” and “data trends”, between Source databases (Oracle PL/SQL), Staging (SQL Server), and Target database. In addition to this routinely monitored the performance of Oracle queries, and SQL Server queries)
• Modified Customer Segment Packages to fix few issues reported.
• Modified Facility claim’s SSIS Packages to implement changes requested to flip Diagnosis Codes, Primary Codes.
• Created the basic framework for archiving Process Configurations, and tie it to the Job Queue, that was in turn used to identify which record was introduced by which run/Process Configuration
• Completely designed, implemented and automated the data validation procedure at BCBSM-CPDM Project. This included the 4 pronged approaches to validate - “DC”, “DA”, “DT”, and “DP”.
• Completed the performance tuning for SI (Supplemental information) SSIS Process. Initially it too about 2 days’ time to load a 200 MB file, after tuning it took less than 5 minutes to load. This involved tweaking of 6 packages, and 50+ stored procedures to reduce potential locking, use more appropriate indexes, partition the data so that swap-in new data from temp tables was quick, and rollback in case of issue was easier.
• Created Scripts in PowerShell to transfer/validate and timestamp files received from the External POs. In case of some failures, sent automated notifications to the support team.
• Wrote 400+ Test cases for SI after major enhancement and bug fixes. Took business approval for each scenario, emails expected for each scenario. Also created 120+ test data file to unit test my code.
• Worked on Many small Ad-hoc implementations for Projects like URMBT (care relationship), MDDataCor (Provider-Member attribution), etc.
• Defined the Strategy for Client to manage Source code using tortoise-SVN (free-tool) for packages, and Tie Databases directly to SVN via Red Gate Source Control.

Confidential, Westmont, Illinois

Senior Consultant/Database Modeler/Architect

• Provided a Design and implemented a solution for managing 500+ connections, so that developers can utilize the correct Connection with most optimal driver. This was a a combination of a backend lookup table with Visual Studio Add-in coded in C# that manages all 500+ Data Sources, so that developers can just select Data Source, and it automatically creates a Connection manager (in SSIS), and Package configuration is automatically tied to a SQL Server Table.
• Created a Framework for the all the SSIS Package, that standardized all packages by leveraging on a standard logging, purging, backing procedures and way to notify the developers.
• Designed and Created 10+ SSIS packages to load data in cubes (SSAS).
• Provided roadmap and actual migration for 30+ DTS Packages to SSIS 2008. During this process, modified SPs to achieve better performance. Also re-written some COM components into C# based libraries and deployed them in GAC.
• Designed and provided data model for on-boarding of Aetna Client, and load into our Cubes for further reporting.
• Gathered requirements, provided design, data model and Created 15+ SQL Server reports to extract data from cubes and show them to end client using SQL Server reporting services.
• Worked on an application named Tracker and introduced major changes in it leveraging WCF Services in combination with jQuery, JSON and telerik Controls for enhanced user experience. This included RadScriptManager, Rad Combo box, and Rad Grid Controls etc.
• Modified reports to include new columns/data to be show in the system.
• Proposed and Implemented TFS (Team foundation Server) usage for version control of SSIS packages and reports in remediation project.
• Migrated 2 DBs based on Microsoft Access 2003 to SQL Server 2008 R2 based DBs. This also involved re-writing of the Queries into SQL Server, to achieve benefits of newer features.
• Create /Modify MDX query to extract data for various reports.
• Added logic for persistence in all the cubes processing SSIS packages. This was required so that client never gets empty reports. This became critical as the previous design was the re-load entire data instead of incremental data load into system.
• Created 5 SSRS reports for the corporate Survey conducted in JPMC (JP Morgan Chase), JPMC-California, BOFA (bank of America), Harris bank, JLL
• Created 10+ SSRS reports for data extracted from one view property application.
• Re-written reports based on MS Access-2003 into SQL Server reports
• Created a Web Service client that extracted data from SQL Server 2008 R2 tables, formed a XML and sent the data via Web Service in a secure mode. (With specific encryption algorithm that was provided). Used tools like Fiddler to test and monitor the interaction. This client was created in C# and was deployed as windows service.
• Supported and then migrated Microsoft Access based Forms into .NET based web forms.
• Created 15+ Reports in SQL Server reporting Services for users at bank of America, HSBC, and Aetna.
• Implemented the User defined functions on SQL Server 2008 R2 to achieve encryption and decryption of file data. This was implemented in C#
• Provided fixes in C# and ASP.NET for web application used for administration and display Old reports build on crystal reports to end users.
• Created 3 crystal reports(8.5 version) for ADA Survey application for end client JP Morgan
• Migrated 220 jobs scheduled in Windows Task Scheduler, to SQL Server 2008 SQL Agent. This was done via SQL Script that created Jobs based on information stored in old controls files, and schedule information was extracted from XML files created in system32 folder by Task scheduler.
• All the Development projects completed at JLL followed Agile Methodology/SCRUM. Typically each cycle lasted for 4 weeks.

Confidential, Schaumburg, Illinois

Release Stream Lead

• Involved with a team to migrate from Oracle 9i DB to Oracle 10g Database.
• Developed Solution for Syndication that totally relies on PL/SQL package (on oracle 10g) querying Vignette System tables and Content Tables. This solution performed approx. 2000% better than the existing solution. Now this solution is being used at Motorola for their BMS Site.
• Designed and Created (10+) SSIS Packages to collect data from different applications into an SQL Server 2005 for further reporting purpose. The database was mainly a OLAP based system.
• Was involved in writing standard stored procedures, SSIS packages for data cleansing, and aggregation of data in tables and further pumping into fact tables, so that it can be consumed directly into reports based on SQL Server reporting services.
• Created (10+) reports and Supported (50+) reports built on SQL Server reporting services 2005.
• Done performance tuning of the database used for other internal applications, using SQL profiler, performance monitor, and query analyzer.
• Provided quick fixes for the MS-Access -2003 based 2 forms to be able to handle special characters.
• Monitored the scheduled Jobs to run SSIS packages
• Created Ad-hoc reports using Excel and advance VBA. This required creating new SQL queries, stored procedures on a SQL Server 2005 based DB, and getting the data into Excel files.
• Provided quick fixes for the .NET based web application used for partner Sites.
• Created Reports that extracted data from HPQC Database repository. The database was SQL Server 2005 based. To accomplish it, created stored procedures in DB. These were consumed by a JSR 168 portlet.
• Worked on the content migration and fixing of the specific references to “ static files” keywords using PL/SQL Procedures
• Created Shell scripts for the Solaris 10 based system to modify the raw files, so that we can use them correctly in a standard way in SSIS packages.
• Created Database Objects for admin Content types definitions in Oracle 10g
• Each Development was done in iterative framework (SCRUM) way of 4 releases each having 4 Sprints in each calendar year, this was a typical agile delivery methodology.
• Created Use cases for various reports for the user, to take approvals.
• Managed a team of 13 offshore resources.

Confidential, Cleveland, Ohio

Senior Developer

• Created 20+ Reports for Client in Hyperion IR v9.3 to show the Orders placed by various stores on daily, weekly and monthly basis. These were further used by “Buyers” to analyze the market trends explore possible ways to boost revenue. These reports were mainly consumed the data from SQL Server, and the GOLD DB repository in Oracle.
• Created (30+) SSIS Packages that validated XMLs with the XSD files (schema definition Files) performed XML Transformations (XSLT) using XSL files (with extensive use of functions, XPATH used to derive custom information from base information available in XMLs). These XMLs were finally consumed by an ETL package written using SSIS, and loaded in SQL Server 2005 database.
• Created (10+) SSIS Packages to generate XML files. These XML files constituted data from Tables and generated XML Files, validated these XML files with a provided XSD (schema definition file), and sent a notification. The Query used to extract the data was a configurable Query stored in a Configuration Table.
• Did the data modeling for the SQL Server side and Oracle Side. This data was further consumed by packages written by developers from Client to push it further into Lawson and POS.
• A Set of the Sales data was pushed into a data warehouse following a snowflake schema. It was essentially cubes in SSAS. Based on this data, created some reports on Hyperion Interactive reports 9.2 as a part of POC.
• Involved in managing the cubes, and cleansing of data whenever required.
• Created custom PL/SQL packages, relying heavily on Database links, Linked Servers. This was necessary as the Oracle Server was located in Nebraska, and the SQL Server was located locally at the corporate office in Cleveland, and the row by row transfer of sales data b/w Oracle and SQL server was important, but speed was equally important. Boosted the performance from 30+minutes to less than 1 minute with new implementation.
• Created Ad-hoc reports using Excel and advance VBA. This required creating new SQL queries, stored procedures, and getting the data into Excel files.
• Created custom AIX shell scripts to clean up the temporary XML files, and cache files used for custom screens/interfaces, and reports.
• Implemented integration with MSMQ (Microsoft Messaging Queues) to extract some XML files (some XMLs were pushed into Queues, and others on a Samba configured Share), and load them to the SQL Server.
• Created XSLs that extensively utilized XPATH, standard XSL 2.0 compliant functions to do XML to XML transformation.
• Created data model for this project, for all the new requirements/enhancements.
• Created Use cases for various reports for the user, to take approvals.
• Done performance tuning of the database, using SQL profiler, performance monitor, and query analyzer.
• Monitored the scheduled Jobs to run SSIS packages
• Managed a team of 3 offshore resources in India, and 1 offsite resource in LA, California.

Confidential, Milwaukee, Wisconsin

Senior Developer

• Migrated data from SQL Server 2000 to SQL Server 2005
• Done performance tuning of the database objects (Tables, Stored Procedures for 100+ objects), Normalize/de-normalize data wherever necessary and ensure data integrity using triggers, and/or transaction blocks in Stored procedures.
• Converted MS Access based data to SQL Server tables, and MS Access Queries to SQL Server Stored procedure. Improved efficiency from several hours to minutes by implementing SQL Server solutions
• Converted 20+ DTS packages to SSIS packages
• Created Maintenance plan using SSIS Packages, and scheduled it as a Job.
• Run SQL Server Profiler to trace and troubleshoot applications.
• Mentored the team for the Log Shipping procedure, created necessary scripts for it.
• Meet with business stakeholders to discuss business needs and application specifications
• Managed Database wide security for various applications
• Created Reports in Excel with advance VBA, for the data extracted from a Defect Tracking Tool “Test director” database. These reports were used to track the defects.
• Done Proof of concept (POC) for 44 contact us forms using Vignette application portal, Vignette Builder. In this task Created WSRP Portlets, customized grids, Styles (HTML/XHTML + CSS + JavaScript using Dreamweaver), and created AXIS 1.4 framework web service to send Emails.
• Migrated the Data, Database objects stored in previous versions of Oracle 8i to Oracle 11i
• Done Manual Testing of the deliverables, from unit testing and peer review Testing perspective.

Confidential, Hoboken, New Jersey

Senior Developer

• Created, Enhanced and Supported the SSIS Packages/ETL that pulled the data from many Desktop MS Access Files from different departments located at 8 offices across the globe. Transformed and loaded it into an ODS in MS SQL Server 2000.
• Created interfaces to extract XML based files (timesheets received from clients) into the SQL Server database. This was done using SSIS packages, and a combination of SQL-XML commands. Once the task was complete generated Emails for the stakeholders automatically.
• Created Ad-hoc reports in Excel using advance VBA. The data was extracted from an ODS built on SQL Server 2000. These reports were for various dimensions like time, domain.
• Enhanced and supported an application built in ASP (HTML + VBScript + JavaScript), and later migrated to VB.NET with ASP.NET (including CSS + HTML + JavaScript) and C# based components. This application was used as a gateway for HR tasks and timesheets for various consultants.
• Created 10+ Reports using SQL Server Reporting Services (SSRS) (using Microsoft Business Intelligence studio BIDS). This included creating Tables, Views, and stored procedures in SQL Server, Scheduled these Reports using a shared schedule for the reports. Used out of box delivery options to send out Emails to various stakeholders, including Accounts, Department, and HR and Managing director of the company. Deployed the reports on the server via SQL Server Management studio. Created and managed the required data sources through SSMS. The reports were specifically related to the financial aspects of the various departments namely life sciences domain, Corp-Corp Consulting, Financial Domain, and Offshore Development. I was the sole person gathering the required knowledge from the business stakeholders, defining the database for optimal Reports performance, creating the Reports and finally getting approval for the Reports.
• Done performance tuning of the database objects in the ODS, using SQL profiler, SQL Query analyzer, performance monitor
• Created scripts for Disaster recovery.
• Ability to work remotely, for globally distributed teams.
• Done Manual Testing of the deliverables, from unit testing and peer review Testing perspective.

Confidential, Weldon Spring, Missouri

Senior Developer

• Created and Supported Stored procedures, views to handle synchronization process between ECARS 1.0 and 2.0.
• Created and Supported SSIS Packages that pulled the data from Oracle 10g System, AS400/IBM DB2, flat files on FTP locations, and XML files. This data was transformed and loaded it into a ODS in MS SQL Server 2005.
• Created reports (20+ reports from scratch) in SQL Server Reporting Services 2005 (SSRS). This also involved creating reports, stored procedures, using shared schedule for the Reports and used out of the box delivery options to send out Emails to various stakeholders
• I gathered the requirements from the marketing managers who dealt with regional managers (manager of the team to handle the root level operations for rentals).
• These reports had data driven subscriptions, as the number of Regional managers were high. I gathered the requirements specific to the daily rentals, like individual sales, callbacks or tickets from Insurance companies for covered rentals etc. These reports were mainly used in the forecasting, and analyzing the performance of each unit (rental locations, car models etc).
• I was also responsible for managing the shared schedule, and custom schedule for each report (which ever applicable)
• Created Ad-hoc reports using Excel and advance VBA. The data was pulled from the ODS built on SQL Server 2005.
• I was part of the team that implemented the snapshot replication of the SQL Server 2005 database.
• Created the integration and supported the SQL Server 2005 Reports (SSRS) integration with an application built in C# and ASP.NET.
• Created and modified the maintenance plans for the database. Create and Monitor jobs running maintenance plans.
• Provide training and mentorship for other analysts/developers in T-SQL script writing, database development, report writing techniques and requirement gathering
• Provided technical analysis to Director of Business Intelligence to design solutions for business groups to reach strategic goals
• Created Scripts for Log Shipping, transferred the knowledge to the team.
• Created Test cases and Done Manual Testing for the delivery from other consultant, as a part of QA Cycle. Documented bugs and suggestions in Excel. Communicated this to the required party.

Confidential

LEAD Engineer

• Created Data Model for the migration Projects and the Enhancements.
• Created Enhanced and Supported Tables, Stored procedures, views in SQL Server 2005. This was used in JSR 168 portlets ported on Vignette application portlets.
• Created Database objects (Tables and Stored procedures). These were used in various Content type Definitions (CTDs)
• Done performance tuning of the database objects to maximize performance.
• Created the maintenance plan using SSIS packages.
• Done back/restore of database for various environments like Development, Testing and Staging environment. Assisted operations team in backup restore for production environment.

Confidential

Team Lead

• Develop New SSIS packages/ETLs and modify existing ETLs for new/changing requirements. These ETLs used to get data from Oracle 9i Database (from specific views), Excel files on FTP locations, and IBM DB2 Database. The SSIS packages loaded the data in SQL Server 2005 Database.
• Supported and enhanced Views using Oracle PL/SQL 9i. These views were used in ETLs.
• Created (10+) and supported (25+) the Reports built using Hyperion Brio 8.3. These reports were built on various dimensions like area, business line, clients, and time on various member elements.
• Created Ad-hoc reports using Excel and advance VBA. This required creating new SQL queries, stored procedures, and getting the data into Excel files.
• Created data model for this project, for all the new requirements/enhancements.
• Created Use cases for various reports for the user, to take approvals.
• Done performance tuning of the database, using SQL profiler, performance monitor, and query analyzer.
• Monitored the scheduled Jobs to run SSIS packages.
• Created Scripts for log Shipping.
• Created Test cases and Done Manual Testing for the delivery from other consultant, as a part of QA Cycle. Documented bugs and suggestions in Excel. Communicated this to the required party.
• Later became Team lead for the team (Team Size -4 regular and 2 contract employees). As a team lead was involved in the requirement gathering and Design of the Reports, and the database aspects.

Confidential

Team Member

• Created New SSIS Packages/ETLs and support existing ETLs. These SSIS Packages used to get data from SQL Server 2000 and Oracle 9i Database. The data was transformed and loaded in SQL Server 2005 (ODS). Database. As a part of my responsibility I was also involved in maintaining the materialized views, stored procedures in Oracle PL/SQL 9i, and the database objects in SQL Server 2000/2005 as well.
• Created and supported SQL Server Reports (SSRS) 2005. To achieve this created Stored procedures, view to get data from ODS.
• Created ad-hoc reports in Excel Sheet, with advance VBA and SQL Queries. These reports were based on dimensions like time, products, specific markets etc.
• Created and Supported the Reports built using Hyperion Brio 8.3. This was for another department that had licenses for Hyperion Brio 8.3.
• Migrated the Hyperion 8.3 reports to Hyperion Interactive Reports 9.2.
• Enhance the Reports built on Hyperion Interactive Reports v9.2. The database for this system was an ODS in SQL Server 2005