SUMMARY

• 12+ years overall IT experience in software architecting, leading and development. In - depth knowledge to Microsoft Products like. NET Framework versions 1.1, 2.0 to 3.5. VB.NET, C#. Net, ASP.NET, SOA, Sharepoint, BizTalk, Visual Basic, Visual C++ 6.0, MS SQL Server 7.0, 2000, 05, 08 and 2012( Denali). SSRS, SSIS, Data DB2, Data Stage, Oracle, PDW, T-SQL, PL SQL, Informix, ERWIN, Sybase.
• Good Knowledge of Data Marts, MDM, Data warehousing, Operational Data Source(ODS), OLAP, OLTP, Data Modeling like Multi-Dimensional Data Modeling, Star Schema, Snow Flake Modeling, Slowly Changing Dimensions (SCD), FACT and Dimension Tables using Analysis Services.
• Strengths include Data Architecture, database administration, production support, Performance Monitoring and Tuning.
• Three years’ experience installing, configuring, testing Hadoop components.
• Worked as Lead Solution Architect / Enterprise Architect with enterprise companies and Cloud Environment like Sales Force, AWS.
• Expert in Business Intelligence Applications using Cognos Tools such as Cognos10.1 & 8.x BI(Report Studio, Analysis Studio, Query studio).
• Experienced in software architecting, leading and development. In-depth knowledge to SAP Products like SAP HANA, BO/ BI, BODS, Xcelsius dashboards, Web Intelligence, Dashboard Designer, Crystal Reports, SLT, SAP BW (BEX), ECC, SAP Design Studio, Data modeling, Tableau, VISIO, Oracle.
• 8+ years of proven DB2 DBA experience expertise in leveraging DB2 database platform for enterprise wide solutions. Work experience includes DB2 Application Programmer/ DB2 Database Administrator.
• Exposed to all phases of software development life cycle (SDLC) including in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem management and escalation procedures.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions
• Expert in working with Data Stage high performance in System Analysis, design, development and implementation of Relational Database and Data Warehousing Systems using IBM Data Stage 8.0.1/7.x/6.x/5.x (Info Sphere Information Server, Web Sphere, Data Stage).
• Involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using dimension modelling with Teradata and Oracle
• Expertise in installing, Configuring and maintenance of SQL Server 2000 / 2005, 2008, 2010 on Standalone, Microsoft Clustered servers and Applying latest Service Packs, Hot fixes and security patches in Windows 2003 Enterprise Server in high availability environment.
• Area of technical expertise also includes ADO.NET, ODBC, Web Services, and XML & XSLT.
• Highly proficient in ETL, T- SQL Data transformations, reporting tools.
• Experience in various extracting, transforming and loading (ETL) data flows using SSIS with complex integration of SQL with oracle, flat file sources and IBM mainframe DB2
• Advanced extensible reporting skills using Crystal Reports and SQL server reporting services (SSRS). Created & formatted cross-tab, conditional, drill-down, top n, summary, form, OLAP, sub reports, Adhoc reports, parameterized reports, interactive reports & custom reports
• Excellent in Migration of SQL Server 2000 to SQL Server 2005 & SQL Server 2005 to SQL Server 2008.
• Vast exposure to the full software life cycle phases (system analysis, design, coding, testing and maintenance.
• Perseverant, meticulous and a committed team player.

TECHNICAL SKILLS

Languages: .NET 1.1/2.0/3.0/3.5, C#.NET, VB.NET, C, C++, JAVA

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Cassandra, Oozie, Flume and Talend

GUI: Sharepoint, MOSS 2007, WSS 3.0,.NET, (Crystal Reports, Active X, ADO.NET), Visual Basic 6.0, T-SQL, Visual C++ 6.0, Siebel, PowerBuilder, NUnit

RDBMS: MS SQL Server 2000, 05, 08 and 2012(Denali). SSRS, SSIS, Oracle.

DBMS: MS Access, AS 400.

Middleware Technologies: COM, COM+, DCOM, ATL, LDAP, Active Directory, MSMQ

Internet Technologies: IIS 6.0, 7.0, HTML, DHTML, Active Server Pages, ASP.NET 3.5, WCF, WPF, Sileverlight, IIS, MTS, VS 2008, Personal web server, XML, Web sphere, MS Site Server 3.0, MS Commerce Server 2000

Tools: ERWIN, Rational Tools, Informix, FTP, EDI. Photo Shop, Visio, Remedy, iSeries,SQL Reporting Services, SQL Navigator, Rapid SQL and TOAD, PVCS and Visual Source Safe

Operating Systems: WINDOWS NT 4.0 / 95 / 98 / 2000, MS DOS, UNIX, XP

Back Office Products: MS Word, LOTUS, and Power Point

PROFESSIONAL EXPERIENCE

Confidential, TX

Lead Database Admin/Enterprise Data Architect

Responsibilities:

• Reviewed all LAPS and MAPS Capabilities and provided consolidated solution to build AMPS.
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design.
• Designed and developed ETL processes using DataStage designer to load data from Oracle, T-SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Worked on CRM Platform environment of SFDC Sales Cloud, Service Cloud modules.
• Worked on salesforce.com standard objects like accounts, leads, contacts, opportunities, reports, and dashboards.
• Created Salesforce communities for customers and partners. Developed reports and dashboards in the communities.
• Installed and configured MapReduce, HIVE and the HDFS; implemented Hadoop cluster on CentOS. Assisted with performance tuning and monitoring.
• Developed MapReduce programs to parse the raw data, populate staging tables and store the refined data in partitioned tables in the EDW.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW reference tables and historical metrics.
• Provided architectural artifacts context view data flow view and Data architecture view.
• Documented all the current state and target state environments and provided blue print.
• Setup meetings with business, technology, infrastructure and database and gave demos about our solution.
• Involved in a data migration process between different versions of Cognos
• We setup real application clustering (RAC) for Oracle data warehouse infrastructure. Provided Solution and diagrams.
• Designed and developed ETL process for migrating LAMPS database to new AMPS database using SSIS and informatica.
• Build new SSRS reporting tool for business users to help customers.
• Efficiently in incorporated various data sources such as Oracle, MS T-SQL, SQL Server, and DB2, Sybase, XML and Flat files into the staging area.
• Worked on Governance process and attend AAC meetings for approval.
• Worked with development team and providing technical specifications.
• Attended agile calls and answering the questions and providing solution for performance issues for current state applications.

Environment: VS 2005, 2008 and 2012, Salesforce, Java, DB2, Big Data, Hadoop, Azure SQL, T-SQL, UNIX, icrosoft SQL Server 2008, Oracle RAC, MDM, Agile,, DB2, Python, IBM Infosphere Datastage 8.5/8.1, Teradata12, MySQL, SSAS, SSIS, SSRS, BIDS, Crystal Reports.

Confidential, TX

Enterprise Data Architect/ Big Data Engineer

Responsibilities:

• Gathering business requirement and Analyze and design and develop this FRD First data project.
• Developed testing environment for FDR data migration. Researched all the database object for this effort and Created snapshots from source and tested with local schema.
• Converted all the SSIS packages into stored procedures as per business need.
• Extensively used Cognos Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
• Worked on Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts.
• Prepared testing scripts for FDR data from source to target. Worked with other team members and coordinated the development.
• Provided demo about Microstrategy features Vs Tableau. Business selected Tableau.
• Worked on building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Developed Tableau visualizations and dashboards using Tableau Desktop.
• Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server.
• Fixed issues in SAS data analytical and advanced analytical reports and turn the SQL to run faster.
• Used OLAP and OLTP and Star schema to design data marts and data warehouse.
• Worked on SQL Server Administration tasks using various backup strategies, database maintenance plan, user (NT/SQL) security authorizations, database creation, Tables, indexes.
• Provided SQL Server database related technical insight on this project for migrating data warehouse.
• Overall Solution Design that includes end-to-end Process Flow, Web Services definitions/message formats/security. Provided ER diagrams and logical data models by using VISIO.
• Reviewed and optimized SSIS packages, SSRS reports and, NET application. Provided document with list of improvements and implemented successfully on Production.
• Worked on performance of the SSRS reports and deployed in production environment.
• Build cubes using SSAS and integrated to SharePoint. Users can user filters to generate reports.
• Redesigned entire database and introduced table partition to keep the historical data.
• Worked with other associate to setup new development, Testing, Staging and Production environments.
• We designed and developed huge data warehouse using ORACLE and RAC solution.
• I have used PowerShell script, commands for SharePoint site administration
• Worked on Terra data scripts. Fixing issues and updating scripts and running query’s.
• Managed and monitor integration database and system performance.
• That includes optimization and tuning of data loads, extractions, and the recommendation of appropriate changes to ensure and improve system performance and reliability.
• Converted some Cognos reports into Tableau reports for financial analysis. We customized to show different categories and different formats. We scheduled to send an email to appropriate folks.

Environment: VS 2005, 2008 and 2012. .NET Framework 4.5, Tableau, SAS, AIX, Big Data, T-SQL, Hadoop, DB2, Azure SQL, Microsoft SQL Server, Cognos, Microstrategy, Oracle 11i, Python, IBM Infosphere Datastage 8.5/8.1, Teradata12, MySQL, MDM, PDW, SSAS, SSIS, SSRS, BIDS, Salesforce, Crystal Reports, Business Objects XI, Report Portal 3.0.

Confidential, TX

Lead Solution Architect

Responsibilities:

• Gathering business requirement and Analyze and design and develop this huge project.
• Provided SQL Server database related technical insight on this project for migrating data warehouse.
• Overall Solution Design that includes end-to-end Process Flow, Web Services definitions/message formats/security. Provided ER diagrams and logical data models by using VISIO.
• Provided solution for logical data diagrams and strategies to bring the data from Source to Target by designing the ETL process by using work flows, data flows, quality transforms, filter the data as per requirements and loading the data in target.
• Developed database triggers and stored procedures using T-SQL cursors and tables.
• Provided architecture artifacts for Big data solutions and integration with other systems. Presented Blue print about Current state and Target state solution.
• Provided solution to load data from different sources to target staging server and design data model using VISIO and providing logical and physical database diagrams and loading data using SSIS and DataStage ETL process.
• Responsible for implementation and ongoing administration of Hadoop infrastructure.
• Deploy new hardware and software environments required for Hadoop and to expand memory and disks on nodes in existing environments
• Converted huge Cogon’s reports in to Business Objects and deployed in to production.
• Created Hive Tables, loaded retail transactional data from Teradata using Scoop.
• Loaded home mortgage data from the existing DWH tables (SQL Server) to EDW using Scoop.
• Wrote Hive Queries to have a consolidated view of the mortgage and retail data.
• Installed UNIX and setup ODBC, DSN. Install third party drive SIMBA Hive and created remote data source to Hadoop to get data real time for reporting.
• Designed cubes using dimensional Start schema’s and published on SharePoint.
• Leading onshore and offshore teams in India and providing all the functional requirements and technical design documents and co-ordination the development.
• Work on proof of concept and prototyping activities to assess whether the proposed architecture and database components meet the non-functional requirements like reliability, scalability, performance and maintainability.
• Generated Complex reports in Microstrategy report studio including Drill Down reports from DMR modeled Frame work model.
• Worked with BI360 suite to build reporting tool for budgeting and dashboard modules.
• Installed and configured MapReduce, HIVE and the HDFS; implemented CDH3 Hadoop cluster on CentOS. Assisted with performance tuning and monitoring.
• Leading the team and providing solution to design and working on agile environment to keep track of the development and providing communication to business and management.
• Teradata V2R12.x systems and used utilities like MultiLoad, FastLoad, FastExport, TPump, Teradata SQL.
• Integrated Business Objects dashboards with SharePoint. Imported all the reports data into our reporting database.
• Created new repositories’ for new requirements and maintain the repository’s and work on role based authentication to provide access to users.

Environment: VS 2005, 2008, .NET Framework 4.5, Microstrategy, Cognos, Salesforce, T-SQL, Hadoop, Microsoft SQL Server, Cognos 8 & 10, Oracle, RAC, PCI, SOX, APS, UNIX, IBM Infosphere Datastage 8.5/8.1, Teradata12, MySQL, QlikView, SSAS, SSIS, SSRS, BIDS, Crystal Reports, Business Objects XI, Report Portal 4.0.

Confidential, Austin, TX

Lead DBA / BI Solution Architect

Responsibilities:

• Understood the multiple systems in short ramp up time.
• Reviewed BRD documents and provide suggestions and feedback.
• Worked on Solution Architecture document for Confidential Digital Download Migration from LTG Infrastructure.
• Worked on various salesforce admin tasks like setting up permission sets, user profiles, email templates, formula fields and validation rules.
• Lead data center transformations projects to migrate client/server applications and platforms to cloud environments.
• All the systems were developed in .NET, ASP.NET, AJAX, Web service, BizTalk, Oracle and MS SQL Server.
• Used to travel and providing solutions and demos about the system process and solutions.
• Transferred technical knowledge to two administrative personnel through providing onsite training, detailed best-practice documentation, architecture, and procedures for DB2 systems.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2000/2005/2008 R2 and 2012.
• Administered Salesforce Cloud based application for Sales, Marketing, and Support departments. Involved in creating multiple analytical reports, with varying degrees of complexity.
• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP HANA Models.
• We Design, Develop, Implementation & Supported, which includes Dynamics AX implementation, .NET development, customization, feature enhancements, and production support sales and distribution reports for business users.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Updated and wrote Python scripts for jobs and data back up and re-covey.
• Created multidimensional star schemas. Define fact tables and dimensional.
• Worked on Governance process and administration.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Planned and developed account migration process for a multi-domain e-mail migration from internal and external AD domains running Exchange 2003/2010 to Google Apps Mail. Migration scripts developed with Powershell.
• Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Developing reports on SSRS on SQL Server ( 2000/2005/2008 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Review current state of Database’s on LTG. Providing solution how to migrate this date in to DF and Product Group. Mapping current state database schema with target state schema and providing solution for data migration.
• Lead team to use libcURL and Apache to communicate via a scalable architecture with Public Cloud Storage that supports Amazon S3, Microsoft Azure, Cloud Services and Salesforce Cloud Services.
• Provided solution for communicating multiple systems with Web services and WCF services.
• Provided demo’s about current state and Target state systems and providing PAD and SAD documents to technical team.

Environment: VS 2005, 2008 and 2012. .NET Framework 4.0, Cloud, Salesforce, Microsoft SQL Server 2008 and DB2, UNIX, SAP HANA 1.0, Business Objects, MySQL, AIX, Azure, Geneva reports, SSAS, SSIS, SSRS, BIDS, CVS, VSS, Crystal Reports, Business Objects XI, Report Portal 3.0.

Confidential, Dallas, TX

Database developer

Responsibilities:

• Deigned entire system for Income call log in information into Database.
• Analyzing business requirements and designs/architects new IVR/Speech solutions
• Created Business, application, database and infrastructure diagrams using Visio.
• Installation of Sql Server 2008 Standard edition and enabling SSIS/SSRS/SSAS on Analytical Development server.
• Comprehensive Cognos Admin Review: Created multiple models to meet the need of adhoc and canned reports. Modified the existed model of Phase 1 and took care of all business needs for phase 2.
• Developed multiple Webi reports for Predictive metrical availability using BI Launchpad. Created universe’s in IDT for all these new reports by using Design Studio. Wrote scripts to customize the some special columns.
• Responsible for upgrades, web services, cloud services with Sales Force, databases, and system configuration for the infrastructure group of Quantum’s storage division.
• Identified and prioritized a Cloud service feature roadmap including object versioning, conditional puts, offsite replication, and performance.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Leading about 25 developers onshore and offshore teams from India and USA. Used to provide design solutions and keep track the development.
• We also follow life cycle process deploying on Dev to Prod and communicate to both business and management.
• Setup CIT and UAT database environments. I also backup and restore the databases on these environments and setup the security for database.
• Worked with developers closely and support on database issues and provide the information about database access. Provided solution for RAC and RAT.
• Analyzed the requirements and worked on Data modeling based on business requirements, designed all master and child tables and relations using VISIO. Also created physical database tables as per Visio diagram.
• Advanced scripting and ETL, data modeling (star schema); worked with large data sets. Used complex QlikView functions and developing most optimal scripts for a given solution.
• Good experience on SQL, relational databases and Dimensional Modeling, Optimization of data model for performance. Backup and restore the data to new tables and also imported from flat files to new tables.
• Set up SSRS and SSIS environments and Created many different types of reports and deployed on CIT and UAT. Supported business, how to use this reports.
• Setup nightly running jobs for data replication from Production to UAT and CIT.
• Tuning and troubleshoot the database issue and support team 24/7.
• Created many complex SSIS packages for data import from other sources to our database’s. We also setup the email notification upon successfully execution of the job. I used to trouble shoot the data issues and support business.
• Designed and developed SSRS Reports using visual studio. Wrote complex queries, stored procedures and functions to fetch the data from database.
• Developed and supported SSRS reports system like Chart reports, Master detail, Drill down, drill through reports.
• Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP HANA Models.
• Designed the database by analyzing the data requirements and created the entire relational database for this project.
• Designed and developed reports in Cognos. Tuning the reports and queries for better performance.
• Worked with tabular reports, matrix reports, gauges & chart reports, parameterized reports, sub reports, ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using Crystal Reports and SQL server reporting services (SSRS).
• Supported and worked on performance tuning for Oracle data warehouse.
• Created ad hoc reports as requested and conduct ad hoc research using Crystal Report XI
• Designed, developed, analyzed Crystal reports from the Business Objects Universe.
• Migrated data from old environments to LLE. Backup and restore and setting up security to different groups and support from MS SQL Server 2005 to 2008.
• Wrote SSIS packages to push data from production to LLE every single night.
• Worked on Data purging, cleaning up the data which is older than 13 months. Archive the data and deleting data using SSIS packages.

Environment: VS 2005, 2008 and 2012. .NET Framework 2.0 and 3.5, C#. NET, Business Objects, Cognos, Microsoft SQL Server 2008 Python, Datastage, Oracle 10g, RAC. RAT, Teradata, T-SQL, PL/SQL, Perl, SSAS, SSIS, SSRS, BIDS, Crystal Reports, Business Objects XI, Internet Information Server (IIS), CVS, MS Excel 2007, Report Portal 3.0.

Confidential, Phoenix, AZ

Lead Database Architect/DBA

Responsibilities:

• Worked with project lead, analyst and business users to understand business processes, document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Designed entire database as per business requirements using Visio. Provided the demo of the data Model and build new database as per Visio.
• Developed SSRS reports like Chart reports, Master detail, Drill down, drill through reports.
• Worked on data center migration from one data center to other data center. We have migrated huge Active reports project to Crystal reports.
• Used Business Objects CrystalXcelsiusand Query as a Web Services (QAAWS) for data access.
• We integrated Remedy system with Crystal reports. We automate this report system flexible to users. So users can enter parameters and generate the reports.
• Designed and developed complicated reports using Crystal Reports.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Involved in creating specifications for ETL processes, finalized requirements and prepared specification document.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Used Business Objects Data Services to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like Oracle 10g/11g, MySQL and SQL Server.
• Involved in deploying SSIS packages for various environments.
• Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, fuzzy look up, for each loop, multi cast, column conversion, fuzzy grouping, and script components.
• Designed and developed reports with running value, interactive sorting as well as conditional formatting.
• Providing solution for design, technical, infrastructure, integration with other external systems like Cognos.
• Reports, matrix reports, gauges & chart reports, parameterized reports, sub reports, ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using SQL server reporting services (SSRS) and Crystal Reports.
• Designed and developed report with running value, interactive sorting as well as conditional formatting

Environment: VS 2005, 2008, .NET Framework, C#. NET, Business Objects, T-SQL, Cognos,Crystal Reports, Microsoft SQL Server 2008/2005 Python, Navision, SSAS, SSIS, SSRS, BIDS, Data Stage 7.5.1 Enterprise Edition, Oracle 10g, Remedy 7.5, IIS, DTS, Data Modeling, ETL, MS Visio, UML, Web Services.