SUMMARY

• Accomplished technical professional with 10+ years of experience in guiding teams and in design and development of various applications for insurance, e - business, Financial, Manufacturing Industries and telecom.
• Lead cross-functional teams with diverse technical backgrounds. Experience in planning, developing and implementing in product life cycle.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Interact with business teams to obtain the business specific data and Understand the QA team's test data strategy and gather the test data requirements.
• In-depth knowledge of Confidential -SQL, SSAS, SSRS, SSIS, OLAP, BI suite, BO, Crystal reports, Qlik view, Tableau, Reporting and Analytics.
• Extensive programming, installing, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2000/2005/2008/2012 and Business Intelligence Studio.
• Experienced in Migrating databases from SQL Server 2000 to SQL Server 2005.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert and DTS/SSIS Packages.
• Extensive experience with SQL Server and Confidential -SQL in constructing complex stored procedures, exceptional handling and debugging stored procedures, triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
• Extensive experience in design techniques, ETL processes, relational database theory, N-Tier development
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS) and Analysis Services (SSAS).
• Excellent report creation skills using Microsoft SQL Reporting Services (SSRS) and Crystal Reports.
• Extensive experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts
• Worked on ASP.NET and C# application to communicate with SQL Server Database.
• Designed and developed OLAP Cubes and Dimensions using SSAS
• Exposure to Hadoop and other Big Data Platforms
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Created and scheduled Jobs, Alerts, SQL Mail Agent and DTS/SSIS Packages.
• An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation.
• A quick learner with an aptitude for taking responsibilities.

TECHNICAL SKILLS

Operating System: Windows NT/98/2000/XP/2003 server/Vista, Unix, Linux.

Tools: /Languages: Pascal, C++, Visual Basic 6.0. Webservices, VB.Net, XML, HTML, Confidential -SQL, PL/SQL, Visual Studio 2003/2005, Eriwin, BIDS.

ETL Tools: DTS, SSIS,SSRS,SSAS,Infomatica.

RDBMS/Database: MS Access, MS SQL Server 7.0/2000/2005 , MySQL4/5, Oracle, TSQL, PL/SQL,MDX, DB2.

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS), Business Intelligence Development Studio(BIDS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, Query Analyzer

Software: MS Office, Visio, Adobe Photoshop, Ms Excel, MS-Project 2000

Web Technologies.: .Net, Coldfusion, Java, ASP.Net

Big Data: Hadoop, Hive, Hbase, SQOOP, Pig

Scripts: Javascript

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports, Business Objects XI

PROFESSIONAL EXPERIENCE

Confidential, New Jersey, NJ

Sr. Business Data Analyst / DBA

Responsibilities:

• Prepared and managed project plan activities and contributes to project plan development in collaboration with project manager.
• Involved in design reviews and provided strategic advice and tactical support to the team for the development, deployment and support.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Got opportunity to work as a accidental DBA and managed multiple Databases .
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Scheduled Heatmap progress check point meeting and managed project Timelines.
• Coordinated documentation, testing, and training efforts related to project plan
• Worked as business analyst for sales productivity dashboard project.
• Involved in capturing requirements, preparing BRD, functional and calculation documents for offshore development team.
• Developed stored procedures to build price Band heatmap reports using SSRS and BI studio by pulling data from the SQL server views.
• Analyzed big data on customer sales Big data.
• Color Coding is implemented in heat map reports to show a partner where they are performing on Confidential Sales In vs. Market (IDC).
• Created the Executive Dashboard landing page displaying the KPI's noted on the IPG Executive Dashboard tab.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and send notifications for loaded and missing files.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Implemented tidal Scheduler for jobs in ITG environment.
• Explored various capabilities and options in power view reporting.
• Developed UI Mockup, technical design and functional specifications for the PPS Executive dashboard Project.
• Worked on database design, views and stored procedures for Mobile POC.
• Developed SCDE supply chain reports using SSRS.
• Worked as a team player who takes end 2 end responsibility of tasks and guides others in completing theirs.

Environment: SQL Server 2008/2012 Enterprise Edition, MYSQL, SQL BI Suite (SSAS, SSIS, SSRS), TOAD, Enterprise manager, SQL Oracle Developer, Tableau, ALM, SharePoint.

Confidential, Atlanta, GA

Senior Oracle, SQL Server, SSIS, SSAS, SSRS, Developer (Consultant)

Responsibilities:

• Developed Executive dashboard, report models and reports using SSRS and BI studio by pulling data from the cubes.
• Developed Technical design documents, scenarios and cases, coordinated with TCS Offshore team.
• Created SSIS packages for data conversion using Data Conversion Transformation.
• Designed and developedSSIS Packagesto import fromWeb services.
• Developed complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Used various Transformations in SSIS Dataflow, Control Flow using For Loop Containers and Fuzzy Lookups etc.
• Hands on experience in using different transformations like Cache, lookup, derived column transformation etc using SSIS.
• Created Oracle Tables, Views, and triggers and stored Procedures and managed source control using Tortoise SVN.
• Designed SSAS Cube involving calculated members and named sets. Developed MDX Scripts to retrieve data from Cube to create Stick Rate Reports and Pivot Tables.
• Developed stored procedures for schedules, reports and other client interfaces.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Worked in Agile environment.
• Involved in creating report models and applying filters for report models.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using Informatica.
• Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package.
• Advanced extensible reporting skills using SQL Server 2005/2008 Reporting Services (SSRS).
• Involved in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Imported Data from MYSQL to Oracle through MYSQL JDBC driver. Worked on Data Migration issues (Varbinary to Char).
• Developed Oracle Stored Procedure to Bulk Insert data into Oracle using BULK COLLECT and COMMIT AFTER 100 RECORDS
• Implemented Oracle ALTER SYSTEM KILL SESSION, Temp Table Space on Oracle Test Environment.
• Created Function Based Index on Oracle table to improve performance.
• Developed RUNNING TOTALS for reporting purpose using Oracle views.
• Implemented Sort Time dimension members in descending order using named query.
• Implemented Event Handlers and Error Handling in SSIS packages.

Environment: SQL Server 2005/2008 Enterprise Edition, Oracle, MYSQL, SQL BI Suite (SSAS, SSIS, SSRS), TOAD, Enterprise manager, SQL Oracle Developer, SharePoint.

Confidential, New Jersey, NJ

SQL Server Developer/SSAS, SSRS, SSIS Developer (Consultant)

Responsibilities:

• Developed client applications (TBIT), report models and reports using SSRS and BI studio by pulling data from the cubes.
• Involved in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects
• Creating and maintaining subscriptions and caching of all Marketing Dashboard reports.
• Created FiOS Daily Driver Report (FDDR) using Excel with SSAS Cube as Data source.
• Written VBA macro to populate the data and formulas to validate the data in FDDR Excel Report
• Experience on upgrading SQL Server . Installed and maintained Microsoft Reporting Services (MSRS) 2008.
• Created reports and performed all Administrative activities. Created Back Up scripts to automate the database refresh from production environment to DEV and QA environments.
• Worked on Cube Processing Tool using SSIS Transformations.
• Design and develop SSIS packages, Confidential -SQL Stored Procedures, configuration files, tables, views, and functions, implement best practices (performance tuning) to maintain optimal performance.
• Fine- tuned the existing reports such as linking sub reports using parameters.
• Designed SSAS Cube involving calculated members and named sets. Developed MDX Scripts to retrieve data from Cube to create Stick Rate Reports and Pivot Tables.
• Built SSAS OLAP cubes that used the built-in SSAS features for the time dimension and associated time intelligence.
• Maintaining CRE/CBSS Reports on VZAI Web Portal for Finance Department.
• Developed stored procedures for schedules, reports and other client interfaces.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition
• Involved in writing MDX Scripts for the OLAP CUBES.
• Involved in creating report models and applying filters for report models.
• Designed and developed various custom defined reports using SQL Server Reporting Services (SSRS) and deployed them on SharePoint 2007 Portal.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Willingness to learn the business and new technology.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Advanced extensible reporting skills using SQL Server 2005/2008 R2 Reporting Services (SSRS).
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Created a separate environment for TBIT(Telecom Business Intelligence Tool)for Frontier in VZAI(.Net) and Reporting Services 2005/2008
• Migrated SQL Server Analysis/OLAP cube databases (around 50 databases) and incorporated security features using dimension level security.
• Provided support for mappings, sessions and workflows in Informatica Power Center.
• Involved actively in identifying what goes for frontier, including creating/cleaning up of cube reports in VZAI.
• Created numerous Reporting Services subscriptions for automatic caching of the RDL reports.
• On the Retain co side, enhanced the cube security to hide the spin co states (Frontier states) data.
• Setup and configure the automatic cube processing tool.

Environment: SQL Server 2005/2008 R2 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS),TOAD, Enterprise manager, MS PowerPoint, MS Project, MS Access 2003 & Windows Server 2003, Oracle, Informatica PowerCenter 8.6.1.

Confidential, GA

Database Developer

Responsibilities:

• Created database triggers/stored procedures and fine tuned to implement complex business rules and automatic background processing.
• Created indexed views, and appropriate indexes to cut the complex query time. Implemented new indexing system reduced report processing time by average of 35%.
• Created DTS packages for migrating data from other data source like Oracle, excel and Access using ActiveX Scripts to upload Data from Text files having Data such as CSV, and Tab space etc., values.
• Developed and enhanced ETL using master and child DTS packages using control flow and data flow functions, passing on parameters on audit table to sync daily loads from the OLTP.
• Scheduling and monitoring of all Confidential -SQL Tasks (DTS Packages)
• Designed various Dimensional models Fact table, Star Schema, and hierarchies.
• Developed an operational data store using OLAP services and DTS packages to perform data scrubbing and warehouse loads. As well as designing of cubes.
• Running MDX queries to create calculated member and to perform conditional tests and comparisons within expressions.
• Developed client applications, report models and reports using SSRS and BI studio by pulling data from the cubes and relational tables using ADO/ADOMD.net.
• Checking the fragmentation of tables and indexes and run DBDEFRAG and DBREINDEX.
• Developed the Functional specification documentation for the modules to be developed.
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
• Worked with report parameters and performed Parameterizedand cascading parameterized reports using SSRS 2005
• Involved in design and deployment ofReport Modelsfor generatingAd-Hocreports as per the client requirements.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases.
• Created Jobs, Alerts and scheduled DTS to generate Reports.

Environment: Confidential -SQL, SQL Server 2000, OLAP Services, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler, Informatica.

Confidential

Sr. Developer

Responsibilities:

• Used FuseBox Methodology.
• Converted existing VB.Net application to CFMX.
• Created programs in Cold Fusion and JavaScript to run various tasks such as user validation, parsing, functioning of site and conversion of XML getting user data for mining purposes
• Design and Development of Synchronization APIs for Outlook, Outlook Express and palm synchronization.
• Coding to transform XML files to Query Objects to meet the backend requirements and transformation of XML documents into WDDX using XSL scripts.
• Involved in Design and development of POP email and browser based email client. Monitored the system performance of web site using weblog analyzer
• Developed few custom tags.
• Involved in database programming. Writing stored procedures.
• Administration of non-production intranet IIS 5.0 web server on a Windows 2000 platform which is primarily used for testing.
• Running backup and restoration of SQL Server 2000/7.0
• Developing WML content compliant to WAP 1.1
• Maintained Clustered CATs in Confidential Application
• Developing few modules in SOAP.

Environment: Coldfusion5.0, VB.Net, ASP.Net, XML, MVC, CFMX, and MS-SQL Server 7.0, MS Project, J2EE, JSP, Web sphere, Visual Source safe, Perl, UNIX