SUMMARY

• Over 10+ years of IT Experience executing several roles - Solution/Integration Architect, Application Architect, ETL/Data Architect, Technical Project Manager, Senior Consultant with Telecom, Healthcare, Insurance, Finance, Retail, and Cloud Server domain
• Extensive experience in Designing Data warehouse, Business Intelligence, Analytics, ETL Process, Data Mining, Data Mapping, Data conversion, Data Migration using Talend, SAP Data Services, SSIS, SSRS, Pentaho Data Integration, Micro strategy, Qlik View
• Extensive experience with Big Data solution using Cassandara, HBase et
• Extensive experience on real time Big Data Integration projects leveraging Talend Big Data components (HDFS, PIG, Hive, Sqoop, HUE et)
• Extensive experience as Ingestion Architect on Designing, Modelling, and Developing Data Lakes based on Big Data Talend ELT integration with Hadoop/Hive/PIG, Kafka, Spark, HBase et
• Extensive experience in designing, and developing SQOOP components, creating Bash/Python scripting
• Very Strong Object-oriented concepts with complete software development life cycle experience - Requirements gathering, Conceptual Design, Analysis, Detail design, Development, System and User Acceptance Testing.
• Experience as working with onsite-offshore models.
• Strong Analytical and Problem Solving skills, Multi-Tasking abilities, with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Java, XML,UNIX Shell,UML,R,C/C+,Pig, Xquery, Servlets, Javascript

Databases: Oracle, TeraData, Netezza, DB2,SYBASE, SQL Server, MySQL, Netezza, HBase, Cassendra

BI Tools: Oracle BI,Hyperion,SAP BW, Pentaho, SAS,SSRS, Tableau, QlikView

ETL Tools: Talend, SSIS, Data Stage, SAP BODS, Pentaho Data Integration (Kettle)

Other Tools: Rational Rose, MS Project, ERWin, PowerDesigner, Data Architect

EAI Tools: IBM Websphere MQ(V5.3, V6.0, V7.5.0.1), IBM Websphere Message Broker(V5.0, V6.1, V7), IIB V9.0.0.1, SAP PI

Big Data: Hadoop, MapReduce, HDFS, HBase, HIVE, Spark,NoSQL databases (Cassandra, HBase, GemFire)

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior RSA ARCHER Consultant

Responsibilities:

• Participated in Requirement gathering, Business Analysis, User meetings and translating user inputs into ETL mapping documents.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the Data Ingestion architecture and Source to Target mapping to load data into Data warehouse
• Extensively leveraged the Talend Big Data components (tHDFSPut, tHDFSOutput, tPigmap,tHive,tHDFSCon et) for Data Ingestion and Data Curation from several heterogeneous data sources
• Responsible for Architecting, Designing, Modelling, and Developing Data Lakes based on Big Data Talend ELT integration with Hadoop/Hive/PIG, Kafka, Spark, HBase et
• Responsible for designing, and developing SQOOP components, creating Bash/Python scripting
• Worked with Data mapping team to understand the source to target mapping rules.
• Prepared both High level and Low level mapping documents.
• Extensively involved in migrating the Ingestion jobs from SAP BODS to Talend 6.1
• Analyzed the requirements and framed the business logic and implemented it using Talend.
• Involved in ETL design and documentation.
• Developed Talend jobs from the mapping documents and loaded the data into the warehouse.
• Involved in end-to-end Testing of Talend jobs.
• Analyzed and performed data integration using Talend open integration suite.
• Worked on the design, development and testing of Talend mappings.
• Wrote complex SQL queries to take data from various sources and integrated it with Talend.
• Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.
• Created ETL job infrastructure using Talend Open Studio.
• Worked on Talend components like tReplace, tmap, tsort and tFilterColumn, tFilterRow etc.
• Used Database components like tMSSQLInput, tOracleOutput etc.
• Worked with various File components like tFileCopy, tFileCompare, tFileExist.
• Developed project specific 'Deployment' job responsible to deploy Talend jar files on to the windows environment as a zip file, later, this zip file is unzipped and the files are again deployed to the unix box, this deployment job is responsible to maintain versioning of the talend jobs dat are deployed in the unix environment.
• Worked on Joblets which is used for reusable code.
• Created sub jobs in parallel to maximize the performance and reduce overall job execution time with the use of parallelize component of Talend in TIS and using the Multithreaded Executions in TOS.
• Worked on TortoiseSVN Server and Repository Browser to manage the Talend jobs files, directories and maintain the version control system
• Developed shell scripts in unix environment to support scheduling of the talend jobs
• Monitored the daily runs, weekly runs and adhoc runs to load data into the target systems.
• Created complex mappings in Talend using components like tMap, tJoin, tReplicate, tParallelize, tSendemail, tDie, tUnique, tFlowToIterate, tSort, tFilterRow and has created various complex jobs
• Implement Error logging/Error handling in all my Jobs.
• Utilized tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats.
• Experienced in versioning, importing and exporting Talend jobs. Set up Triggers for Talend jobs in Job conductor.
• Designed and implemented a Cassandra noSQL based database and associated RESTful web service dat persists high-volume user profile data for vertical teams.
• Migrated high-volume OLTP transactions from Oracle to Cassandra in order to reduce Oracle licensing footprint
• Created architecture stack blueprint for data access with noSQL; used as the technical basis for new Cassandra projects.
• Lead role in noSQL column family design, client access software, Cassandra tuning; during migration from Oracle based data stores

Confidential, Houston, TX

Senior RSA ARCHER Consultant

Responsibilities:

• Created ETL/Talend jobs both design and code to process data to target databases.
• Created Talend jobs to load data into various Oracle tables. Utilized Oracle stored procedures and wrote few Java code to capture globalmap variables and use them in the job.
• Created Talend jobs to copy the files from one server to another and utilized Talend FTP components.
• Created Implicit, local and global Context variables in the job.
• Responsible for creating fact, lookup, dimension, staging tables and other database objects like views, stored procedure, function, indexes and constraints.
• Developed complex Talend ETL jobs to migrate the data from flat files to database.
• Implemented custom error handling in Talend jobs and also worked on different methods of logging.
• Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobsand daily batches for executing the Talend Jobs.
• Wrote complex SQL queries to inject data from various sources and integrated it with Talend.
• Worked on Talend Administration Console (TAC) for scheduling jobs and adding users.
• Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.
• Implemented Error handling in Talend to validate the data Integrity and data completeness for the data from the Flat File
• Created Unix Scripts and run them using tSSH and tSystem for reading the Data from flat files and archiving the Flat files Confidential the specified server.
• Tuned sources, targets and jobs to improve the performance.
• Monitor; troubleshoot batches and jobs for weekly and monthly extracts from various data sources across all platforms to the target database.
• Provided the Production Support by running the jobs and fixing the bugs.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions

Confidential, Louisville, KT

Senior RSA ARCHER Consultant

Responsibilities:

• Understanding the client requirements and creating the project estimate document.
• Create the functional requirement, technical design, unit testing and IQOQ documents.
• Experience in working with SSAS in creating data sources, data source views, named queries, calculated columns, cubes, dimensions, roles and deploying of analysis services projects.
• SSAS Cube Analysis using MS-Excel and PowerPivot.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes Implemented with Dimensional Data Modeling Star and Snow Flakes Schema.
• Defining Regular, Referenced, Many-to-Many relationships and creating Hierarchies key.
• Creating MDX queries with Calculations, KPIs, Actions and Partitions, Aggregations in SSAS.
• Creating Calculations with new Calculated Member, New Script Command and New Nameset.
• Defined attribute properties in a Parent Child Dimensions. Responsible for hiding and disabling attributes hierarchies. Sorting attributes members based on a secondary attribute.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries.
• Creating users Role base security (permissions) for cubes, dimensions, measure groups etc.
• Deploying the Cubes, Dimensions and Partitions in DEV, UAT and Production/Live servers.
• Creating Tables, Views/Index Views with relationships in the MS SQL Server 2012.
• Experience with maintaining databases including updating statistics, re-indexing, structure modifications, index analysis and restore and backup database.
• Played key role in building Architectural Decision document which captures decision points
• Created Detailed Design, Mapping and Unit test case document
• Designed and developed highly performing IIB solutions using best practices
• Design and development of Caching solutions for Allergy crosswalk for better performance
• Designed and developed highly efficient aggregation solution for parallel processing to achieve maximum performance
• Designed the integration of IIB with WSRR and developed mediation policy enforcement solutions for MQ based transactions
• Helped in establishing proxy services in Datapower and enforcing mediation policies for service governance
• Helped in establishing Business services in WSRR and assign the policies for these services for governance
• Extensively involved in Enterprise Performance testing and tuning of WMQ/IIB solutions and Datapower configurations to establish highly available environment and to support very high volume transactions
• Helped in configuring build tool “QuickBuild” to build and deploy IIB services using Ant scripts

Confidential, Chicago, IL

Project manager/Sr. Integration Consultant

Responsibilities:

• Involved in design and development phases of Software Development Life Cycle (SDLC)
• Involved in designing UML Use case diagrams, Class diagrams, and Sequence diagrams using Rational Rose.
• Followed agile methodology and SCRUM meetings to track, optimize and tailored features to customer needs.
• Developed user interface using JSP, JSP Tag libraries, and Java Script to simplify the complexities of the application.
• Implemented Model View Controller (MVC) architecture using Jakarta Struts frameworks Confidential presentation tier.
• Developed a Dojo based front end including forms and controls and programmed event handling.
• Implemented SOA architecture with web services using JAX-RS (REST) and JAX-WS (SOAP)
• Developed various Enterprise Java Bean components to fulfill the business functionality.
• Created Action Classes which route submittals to appropriate EJB components and render retrieved information.
• Validated all forms using Struts validation framework and implemented Tiles framework in the presentation layer.
• Used Core java and object oriented concepts.
• Extensively used Hibernate in data access layer to access and update information in the database.
• Used Spring Framework for Dependency injection and integrated it with the Struts Framework and Hibernate.
• Used JDBC to connect to backend databases, Oracle and SQL Server 2005.
• Proficient in writing SQL queries, stored procedures for multiple databases, Oracle and SQL Server 2005.
• Wrote Stored Procedures using PL/SQL. Performed query optimization to achieve faster indexing and making the system more scalable.
• Deployed application on windows using IBM Web Sphere Application Server.
• Used Java Messaging Services (JMS) for reliable and asynchronous exchange of important information such as payment status report.
• Used Web Services - WSDL and REST for getting credit card information from third party and used SAX and DOM XML parsers for data retrieval.
• Implemented SOA architecture with web services using Web Services like JAX-WS.
• Used ANT scripts to build the application and deployed on Web Sphere Application Server
• Development of MqList utility which lists MQ queue properties
• Enhancement, bug fixing and testing of MqToolkit utilities
• Development of Expect scripts on Solaris and Windows to automate test suite bug fixing and documentation
• Developed Java programs using MQ API dat is invoked by triggered processes.
• Developed Java wrapper classes using JMS to interface with MQ Series
• Developed backup and recovery procedures for MQ Series
• Installed and Configured MQ and Message Broker on Windows and Unix environments
• Troubleshooting, testing and debugging MQSI messages flows using Trace nodes and error handling nodes
• Developed message sets and message flows to transform messages from XML to copybook, TDS to XML, XML to CWF message formats
• Designed and implemented the Publish/Subscribe message pattern.
• Developed customized Java utilities, Scripts to start and stop WebSphere MQ.
• Responsible for 24X7 support of WebSphere MQ and Message broker environment.
• Troubleshooting and debugging production issues.
• End to end interface Analysis which involves debugging in Message Broker, WAS and MQ Series.
• Designed and developed the business requirement by performing extensivedocument analysis, requirement analysis including data analysis and gap analysis for new projects and createdUse Cases,Activity Diagrams, Sequence Diagramsto gather understanding of the process flow.
• Created and handledSCR, RFCusingSerena Business managerto track the software changes flow
• Used and made changes toAntbuild files to handle various project related targets
• Developed and Deployed variousSOAP,RESTfulweb serviceson aweb logicapplication server to manage production issues and support new business requirements related toweb services
• Created and ConfiguredJMS MessageQueues/data sources onweblogic serverfor related web services.
• DevelopedRestFulServices and consumed inXML/JSONformat inAndroidapplication
• UsedVisual VM, MAT, App Dynamicsto analyze memory related issues of the JVM.
• Used the existing code base to investigate the root cause of the production issue and handled the improvements to avoid the issues for the future use usingEclipseandCVS